APPS.PAY_FR_DUCS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 21: g_company_id hr_all_organization_units.organization_id%TYPE;

17:
18: g_business_group_id per_business_Groups.business_group_id%TYPE;
19: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
20:
21: g_company_id hr_all_organization_units.organization_id%TYPE;
22: g_period_type varchar2(60);
23: g_period_start_date date;
24: g_effective_date date;
25: g_english_base varchar2(20) := 'Base';

Line 1551: FROM hr_all_organization_units o

1547: , comp_rep_info.ORG_INFORMATION9 Administrator_Line_1
1548: , comp_rep_info.ORG_INFORMATION10 Administrator_Line_2
1549: , comp_rep_info.ORG_INFORMATION11 Administrator_Telephone_Number
1550: , comp_rep_info.ORG_INFORMATION12 Administrator_FAX_Number
1551: FROM hr_all_organization_units o
1552: , hr_locations l
1553: , hr_organization_information comp_info
1554: , hr_organization_information rep_estab_info
1555: , hr_organization_information comp_rep_info

Line 1631: , hr_all_organization_units urssaf

1627: FROM hr_organization_information estab_info
1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf
1632: , hr_all_organization_units assedic
1633: , hr_locations_all urssaf_loc
1634: , hr_locations_all assedic_loc
1635: WHERE estab_info.org_information1 = p_company_id_chr

Line 1632: , hr_all_organization_units assedic

1628: , hr_organization_information estab_urssaf_info
1629: , hr_organization_information estab_assedic_info
1630: , hr_organization_information estab_rep_info
1631: , hr_all_organization_units urssaf
1632: , hr_all_organization_units assedic
1633: , hr_locations_all urssaf_loc
1634: , hr_locations_all assedic_loc
1635: WHERE estab_info.org_information1 = p_company_id_chr
1636: and estab_info.org_information_context = 'FR_ESTAB_INFO'

Line 1686: , hr_all_organization_units pens_prov

1682: , pens_prov_info.ORG_INFORMATION13 Payment_3_Account
1683: , pens_prov_info.ORG_INFORMATION14 Payment_3_Type
1684: , pens_prov_info.ORG_INFORMATION15 Payment_3_Limit
1685: FROM hr_organization_information pens_prov_info
1686: , hr_all_organization_units pens_prov
1687: , hr_locations_all pens_loc
1688: WHERE pens_prov_info.organization_id = g_company_id
1689: and pens_prov_info.org_information_context = 'FR_COMP_PE_PRVS'
1690: and pens_prov_info.org_information1 = pens_prov.organization_id