APPS.PAY_FR_DADS_ESTAB_COMP dependencies on FND_TERRITORIES

Line 103: l_country_name fnd_territories.nls_territory%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) ;
106: l_version varchar2(20) ;
107: l_service_code varchar2(4) ;

Line 165: fnd_territories ft_issue_estab

161: hr_organization_information hoi_cre_estab,
162: hr_organization_information hoi_cre_comp,
163: hr_organization_information hoi_cre_dads,
164: --
165: fnd_territories ft_issue_estab
166: --
167: Where hou_issue_estab.organization_id = p_param_issuing_estab_id
168: and hou_issue_estab.business_group_id = p_param_business_group_id
169: --

Line 956: l_hq_addr_country_name fnd_territories.nls_territory%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;
959: l_fisc_location_name hr_locations_all_tl.location_code%TYPE;
960: l_name_fisc_estab hr_all_organization_units_tl.name%TYPE;

Line 968: l_fisc_addr_country_name fnd_territories.nls_territory%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);
971: l_cre_media hr_organization_information.org_information1%TYPE;
972: l_cre_estab_id hr_organization_information.organization_id%TYPE;

Line 1052: fnd_territories ft_hq,

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,
1056: hr_organization_information hoi_cre_estab,

Line 1053: fnd_territories ft_fisc_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,
1056: hr_organization_information hoi_cre_estab,
1057: hr_organization_information hoi_cre_comp,

Line 2076: l_estab_addr_country_name fnd_territories.nls_territory%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 ;
2079: l_assg_action_id number;
2080: l_value fnd_new_messages.message_text%type;

Line 2116: fnd_territories ft_estab,

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: --
2120: where hou_estab.organization_id = p_estab_id