DBA Data[Home] [Help]

APPS.PAY_FR_ARC_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 969: from hr_all_organization_units_tl urssaf,

965: --
966: cursor csr_urssaf (p_urssaf_id number) is
967: select urssaf_info.org_information1 code,
968: substr(urssaf.name,1,150) urssaf_name
969: from hr_all_organization_units_tl urssaf,
970: hr_organization_information urssaf_info
971: where urssaf.language = userenv('lang')
972: and urssaf.organization_id = urssaf_info.organization_id
973: and urssaf_info.org_information_context = 'FR_URSSAF_CENTR_INFO'

Line 993: hr_all_organization_units_tl comptl,

989: from pay_assignment_actions paa1
990: where paa1.payroll_action_id = p_payroll_action_id) tax_unit,
991: hr_organization_information est_info,
992: hr_all_organization_units comp,
993: hr_all_organization_units_tl comptl,
994: hr_organization_information comp_info,
995: hr_locations_all addr
996: where addr.location_id(+) = comp.location_id
997: and comptl.organization_id = comp.organization_id

Line 1020: , hr_all_organization_units_tl esttl

1016: est_info.org_information1 company_org_id,
1017: est.location_id
1018: from hr_all_organization_units est
1019: , hr_organization_information est_info
1020: , hr_all_organization_units_tl esttl
1021: , pay_assignment_Actions paa
1022: where paa.payroll_action_id = p_payroll_action_id
1023: and est.organization_id = paa.tax_unit_id
1024: and est_info.organization_id(+) = est.organization_id

Line 1672: ,hr_all_organization_units_tl orgtl

1668: ,hr_all_positions_f_tl postl
1669: ,per_collective_agreements cag
1670: ,hr_all_organization_units est
1671: ,hr_organization_information estinfo
1672: ,hr_all_organization_units_tl orgtl
1673: ,per_contracts_f ctr
1674: ,fnd_lookup_values hrl
1675: ,fnd_lookup_values hrl1
1676: where asg.assignment_id = p_assignment_id