Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Tax Employee Card/ Economic Zone
I'm trying to pull the Economic Zones for Mexico, but it seems that the query I'm using is only returning one single value as "A" where other values should be found as well (e.g 'Zone B (Source: TRU-CD JUAREZ CHI Reg Pat AZ').
select
cd.name,
ao.prompt,
ri.value1,
ri.legislation_code,
ri.legislative_data_group_id
from
pay_allow_overrides_vl ao,
pay_value_defnitions_vl vd,
pay_range_items_f ri
where 1=1
and ri.value_Defn_id = vd.value_Defn_id
and vd.legislation_code = ´MX'
source_id is showing empty for Mexico employees, so there's no way to use a join for this field.
Tagged:
0