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.PAY_FR_DADS_ESTAB_COMP dependencies on HR_LOCATIONS_ALL

Line 96: l_complement hr_locations_all.address_line_2%TYPE ;

92: l_nic varchar2(7) ;
93: l_name hr_all_organization_units_tl.name%TYPE ;
94: l_name_comp hr_all_organization_units_tl.name%TYPE ;
95: l_location hr_all_organization_units.location_id%TYPE ;
96: l_complement hr_locations_all.address_line_2%TYPE ;
97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;

Line 97: l_street_and_number hr_locations_all.address_line_1%TYPE ;

93: l_name hr_all_organization_units_tl.name%TYPE ;
94: l_name_comp hr_all_organization_units_tl.name%TYPE ;
95: l_location hr_all_organization_units.location_id%TYPE ;
96: l_complement hr_locations_all.address_line_2%TYPE ;
97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;
101: l_town hr_locations_all.town_or_city%TYPE ;

Line 98: l_insee hr_locations_all.region_2%TYPE ;

94: l_name_comp hr_all_organization_units_tl.name%TYPE ;
95: l_location hr_all_organization_units.location_id%TYPE ;
96: l_complement hr_locations_all.address_line_2%TYPE ;
97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;
101: l_town hr_locations_all.town_or_city%TYPE ;
102: l_country_code varchar2(30) ;

Line 99: l_small_town hr_locations_all.region_3%TYPE ;

95: l_location hr_all_organization_units.location_id%TYPE ;
96: l_complement hr_locations_all.address_line_2%TYPE ;
97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;
101: l_town hr_locations_all.town_or_city%TYPE ;
102: l_country_code varchar2(30) ;
103: l_country_name fnd_territories.nls_territory%TYPE;

Line 100: l_postal_code hr_locations_all.postal_code%TYPE ;

96: l_complement hr_locations_all.address_line_2%TYPE ;
97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;
101: l_town hr_locations_all.town_or_city%TYPE ;
102: l_country_code varchar2(30) ;
103: l_country_name fnd_territories.nls_territory%TYPE;
104: l_software varchar2(20) ;

Line 101: l_town hr_locations_all.town_or_city%TYPE ;

97: l_street_and_number hr_locations_all.address_line_1%TYPE ;
98: l_insee hr_locations_all.region_2%TYPE ;
99: l_small_town hr_locations_all.region_3%TYPE ;
100: l_postal_code hr_locations_all.postal_code%TYPE ;
101: l_town hr_locations_all.town_or_city%TYPE ;
102: l_country_code varchar2(30) ;
103: l_country_name fnd_territories.nls_territory%TYPE;
104: l_software varchar2(20) ;
105: l_provider varchar2(10) ;

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 158: hr_locations_all hloc_issue_estab,

154: hr_all_organization_units_tl hoi_cre_comp_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,

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 949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;

945: l_partition_number varchar2(4);
946: l_currency_type varchar2(5);
947: l_NIC_HQ_estab varchar2(7);
948: l_name_estab hr_all_organization_units_tl.name%TYPE;
949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;
950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;

Line 950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;

946: l_currency_type varchar2(5);
947: l_NIC_HQ_estab varchar2(7);
948: l_name_estab hr_all_organization_units_tl.name%TYPE;
949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;
950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;
954: l_hq_addr_town_city hr_locations_all.town_or_city%TYPE;

Line 951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;

947: l_NIC_HQ_estab varchar2(7);
948: l_name_estab hr_all_organization_units_tl.name%TYPE;
949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;
950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;
954: l_hq_addr_town_city hr_locations_all.town_or_city%TYPE;
955: l_hq_addr_country_code varchar2(30);

Line 952: l_hq_addr_town hr_locations_all.region_3%TYPE;

948: l_name_estab hr_all_organization_units_tl.name%TYPE;
949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;
950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;
954: l_hq_addr_town_city hr_locations_all.town_or_city%TYPE;
955: l_hq_addr_country_code varchar2(30);
956: l_hq_addr_country_name fnd_territories.nls_territory%TYPE;

Line 953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;

949: l_hq_addr_complement hr_locations_all.address_line_2%TYPE;
950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;
954: l_hq_addr_town_city hr_locations_all.town_or_city%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);

Line 954: l_hq_addr_town_city hr_locations_all.town_or_city%TYPE;

950: l_hq_addr_nn_street hr_locations_all.address_line_1%TYPE;
951: l_hq_addr_insee_code hr_locations_all.region_2%TYPE;
952: l_hq_addr_town hr_locations_all.region_3%TYPE;
953: l_hq_addr_zip_code hr_locations_all.postal_code%TYPE ;
954: l_hq_addr_town_city hr_locations_all.town_or_city%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;

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 961: l_fisc_addr_complement hr_locations_all.address_line_2%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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;

Line 962: l_fisc_addr_nn_street hr_locations_all.address_line_1%TYPE;

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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;
966: l_fisc_addr_town_city hr_locations_all.town_or_city%TYPE;

Line 963: l_fisc_addr_insee_code hr_locations_all.region_2%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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;
966: l_fisc_addr_town_city hr_locations_all.town_or_city%TYPE;
967: l_fisc_addr_country_code varchar2(30);

Line 964: l_fisc_addr_town hr_locations_all.region_3%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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;
966: l_fisc_addr_town_city hr_locations_all.town_or_city%TYPE;
967: l_fisc_addr_country_code varchar2(30);
968: l_fisc_addr_country_name fnd_territories.nls_territory%TYPE;

Line 965: l_fisc_addr_zip_code hr_locations_all.postal_code%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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;
966: l_fisc_addr_town_city hr_locations_all.town_or_city%TYPE;
967: l_fisc_addr_country_code varchar2(30);
968: l_fisc_addr_country_name fnd_territories.nls_territory%TYPE;
969: l_cre_siren hr_organization_information.org_information1%TYPE;

Line 966: l_fisc_addr_town_city hr_locations_all.town_or_city%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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;
965: l_fisc_addr_zip_code hr_locations_all.postal_code%TYPE ;
966: l_fisc_addr_town_city hr_locations_all.town_or_city%TYPE;
967: l_fisc_addr_country_code varchar2(30);
968: l_fisc_addr_country_name fnd_territories.nls_territory%TYPE;
969: l_cre_siren hr_organization_information.org_information1%TYPE;
970: l_cre_nic varchar2(7);

Line 1050: hr_locations_all hloc_hq,

1046: hr_organization_information hoi_hq_estab,
1047: hr_organization_information hoi_fisc_estab,
1048: hr_all_organization_units hou_hq_estab,
1049: hr_all_organization_units hou_fisc_estab,
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,

Line 1051: hr_locations_all hloc_fisc_estab,

1047: hr_organization_information hoi_fisc_estab,
1048: hr_all_organization_units hou_hq_estab,
1049: hr_all_organization_units hou_fisc_estab,
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,

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 2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;

2065: l_effective_date Date;
2066: l_estab_siren hr_organization_information.org_information1%TYPE ;
2067: l_estab_nic varchar2(7) ;
2068: l_estab_name hr_all_organization_units_tl.name%TYPE ;
2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;
2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;

Line 2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;

2066: l_estab_siren hr_organization_information.org_information1%TYPE ;
2067: l_estab_nic varchar2(7) ;
2068: l_estab_name hr_all_organization_units_tl.name%TYPE ;
2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;
2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;
2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;

Line 2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;

2067: l_estab_nic varchar2(7) ;
2068: l_estab_name hr_all_organization_units_tl.name%TYPE ;
2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;
2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;
2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;
2075: l_estab_addr_country_code varchar2(30) ;

Line 2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;

2068: l_estab_name hr_all_organization_units_tl.name%TYPE ;
2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;
2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;
2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;
2075: l_estab_addr_country_code varchar2(30) ;
2076: l_estab_addr_country_name fnd_territories.nls_territory%TYPE ;

Line 2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;

2069: l_estab_addr_complement hr_locations_all.address_line_2%TYPE ;
2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;
2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;
2075: l_estab_addr_country_code varchar2(30) ;
2076: l_estab_addr_country_name fnd_territories.nls_territory%TYPE ;
2077: l_estab_headcount_3112 number ;

Line 2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;

2070: l_estab_addr_nn_street hr_locations_all.address_line_1%TYPE ;
2071: l_estab_addr_insee_code hr_locations_all.region_2%TYPE ;
2072: l_estab_addr_town hr_locations_all.region_3%TYPE ;
2073: l_estab_addr_zip_code hr_locations_all.postal_code%TYPE ;
2074: l_estab_addr_town_city hr_locations_all.town_or_city%TYPE ;
2075: l_estab_addr_country_code varchar2(30) ;
2076: l_estab_addr_country_name fnd_territories.nls_territory%TYPE ;
2077: l_estab_headcount_3112 number ;
2078: l_estab_salary_tax_code hr_organization_information.org_information3%TYPE ;

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 2114: hr_locations_all hloc_estab,

2110: hr_organization_information hoi_estab,
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

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: --