APPS.PAY_FR_DADS_ESTAB_COMP dependencies on HR_LOCATIONS_ALL_TL

Line 122: l_location_name hr_locations_all_tl.location_code%TYPE;

118: l_error_type hr_lookups.meaning%type;
119: l_error hr_lookups.meaning%type;
120: l_warning hr_lookups.meaning%type;
121: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;
122: l_location_name hr_locations_all_tl.location_code%TYPE;
123: --
124: Cursor csr_get_S10_G00 is
125: Select hoi_issue_comp.org_information1 SIREN_issue_estab,
126: substr(hoi_issue_estab.org_information2, length(hoi_issue_estab.org_information2)-4, 5) NIC_issue_estab,

Line 159: hr_locations_all_tl hloc_issue_estab_tl,

155: hr_organization_information hoi_issue_estab_cre,
156: hr_organization_information hoi_issue_estab,
157: hr_organization_information hoi_issue_comp,
158: hr_locations_all hloc_issue_estab,
159: hr_locations_all_tl hloc_issue_estab_tl,
160: --
161: hr_organization_information hoi_cre_estab,
162: hr_organization_information hoi_cre_comp,
163: hr_organization_information hoi_cre_dads,

Line 943: l_location_name hr_locations_all_tl.location_code%TYPE;

939: --
940: l_siren_comp hr_organization_information.org_information1%TYPE;
941: l_name_comp hr_all_organization_units_tl.name%TYPE;
942: l_location hr_all_organization_units.location_id%TYPE;
943: l_location_name hr_locations_all_tl.location_code%TYPE;
944: l_cal_year varchar2(10);
945: l_partition_number varchar2(4);
946: l_currency_type varchar2(5);
947: l_NIC_HQ_estab varchar2(7);

Line 959: l_fisc_location_name hr_locations_all_tl.location_code%TYPE;

955: l_hq_addr_country_code varchar2(30);
956: l_hq_addr_country_name fnd_territories.nls_territory%TYPE;
957: l_NIC_fisc_estab varchar2(7);
958: l_fisc_location hr_all_organization_units.location_id%TYPE;
959: l_fisc_location_name hr_locations_all_tl.location_code%TYPE;
960: l_name_fisc_estab hr_all_organization_units_tl.name%TYPE;
961: l_fisc_addr_complement hr_locations_all.address_line_2%TYPE;
962: l_fisc_addr_nn_street hr_locations_all.address_line_1%TYPE;
963: l_fisc_addr_insee_code hr_locations_all.region_2%TYPE ;

Line 1054: hr_locations_all_tl hloc_hq_tl,

1050: hr_locations_all hloc_hq,
1051: hr_locations_all hloc_fisc_estab,
1052: fnd_territories ft_hq,
1053: fnd_territories ft_fisc_estab,
1054: hr_locations_all_tl hloc_hq_tl,
1055: hr_locations_all_tl hloc_fisc_estab_tl,
1056: hr_organization_information hoi_cre_estab,
1057: hr_organization_information hoi_cre_comp,
1058: hr_organization_information hoi_cre_dads

Line 1055: hr_locations_all_tl hloc_fisc_estab_tl,

1051: hr_locations_all hloc_fisc_estab,
1052: fnd_territories ft_hq,
1053: fnd_territories ft_fisc_estab,
1054: hr_locations_all_tl hloc_hq_tl,
1055: hr_locations_all_tl hloc_fisc_estab_tl,
1056: hr_organization_information hoi_cre_estab,
1057: hr_organization_information hoi_cre_comp,
1058: hr_organization_information hoi_cre_dads
1059: where hou_comp_tl.organization_id = p_company_id

Line 2085: l_location_name hr_locations_all_tl.location_code%TYPE;

2081: l_error_type hr_lookups.meaning%type;
2082: l_error hr_lookups.meaning%type;
2083: l_warning hr_lookups.meaning%type;
2084: l_estab_location hr_all_organization_units.location_id%TYPE;
2085: l_location_name hr_locations_all_tl.location_code%TYPE;
2086: l_name_comp hr_all_organization_units_tl.name%TYPE ;
2087: --
2088: -- Cursor for s80 data
2089: cursor csr_S80_G01_00 is

Line 2115: hr_locations_all_tl hloc_estab_tl,

2111: hr_organization_information hoi_estab_comp,
2112: hr_all_organization_units_tl hoi_estab_comp_tl,
2113: --
2114: hr_locations_all hloc_estab,
2115: hr_locations_all_tl hloc_estab_tl,
2116: fnd_territories ft_estab,
2117: --
2118: hr_organization_information hoi_sal_tax
2119: --