eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_DIF_STMT_REPORT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 71: 'pay_accrual_plans acc, hr_all_organization_units estab';

67: -- Get a list of employees for this establishment
68: -- and accrual plan, if any
69: -- Build the query dynamically
70: l_select := 'select distinct per.person_id emp_id, estab.organization_id estab_id, per.full_name name, per.employee_number empnum from per_all_people_f per, per_all_assignments_f ass, pay_element_entries_f ent, '||
71: 'pay_accrual_plans acc, hr_all_organization_units estab';
72: l_where := ' where per.person_id = ass.person_id and per.business_group_id = '||p_business_group_id||' and '|| '''' ||l_date_to|| ''''||' between per.effective_start_date '
73: ||'and per.effective_end_date and estab.business_group_id = per.business_group_id and ass.establishment_id = estab.organization_id '
74: ||'and ass.effective_end_date >= '|| '''' ||l_date_from|| ''''||' and ass.effective_start_date <= '|| '''' ||l_date_to|| ''''||' and ass.assignment_id = ent.assignment_id '
75: ||'and ent.element_type_id = acc.accrual_plan_element_type_id and acc.accrual_plan_id = '||p_accrual_plan_id||' and ent.effective_end_date >= '|| '''' ||l_date_from|| ''''||' and ent.effective_start_date <= '|| '''' ||l_date_to|| ''''||'';

Line 235: from hr_all_organization_units estab,

231: 'er_hdr_comp_country',
232: comp_ft.nls_territory,
233: 'er_hdr_estab_siret',
234: estab_info.org_information2
235: from hr_all_organization_units estab,
236: hr_all_organization_units_tl estab_tl,
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,

Line 236: hr_all_organization_units_tl estab_tl,

232: comp_ft.nls_territory,
233: 'er_hdr_estab_siret',
234: estab_info.org_information2
235: from hr_all_organization_units estab,
236: hr_all_organization_units_tl estab_tl,
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,

Line 237: hr_all_organization_units comp,

233: 'er_hdr_estab_siret',
234: estab_info.org_information2
235: from hr_all_organization_units estab,
236: hr_all_organization_units_tl estab_tl,
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,

Line 238: hr_all_organization_units_tl comp_tl,

234: estab_info.org_information2
235: from hr_all_organization_units estab,
236: hr_all_organization_units_tl estab_tl,
237: hr_all_organization_units comp,
238: hr_all_organization_units_tl comp_tl,
239: hr_organization_information estab_info,
240: hr_locations_all estab_loc,
241: hr_locations_all comp_loc,
242: fnd_territories estab_ft,