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_ALL_ORGANIZATION_UNITS_TL

Line 93: l_name hr_all_organization_units_tl.name%TYPE ;

89: IS
90: --
91: l_siren hr_organization_information.org_information1%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 ;

Line 94: l_name_comp hr_all_organization_units_tl.name%TYPE ;

90: --
91: l_siren hr_organization_information.org_information1%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 ;

Line 121: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;

117: l_value fnd_new_messages.message_text%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,

Line 152: hr_all_organization_units_tl hou_issue_estab_tl,

148: hoi_cre_estab.organization_id cre_estab_org_id,
149: hou_cre_estab_tl.name name_cre_estab
150: --
151: From hr_all_organization_units hou_issue_estab,
152: hr_all_organization_units_tl hou_issue_estab_tl,
153: hr_all_organization_units_tl hou_cre_estab_tl,
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,

Line 153: hr_all_organization_units_tl hou_cre_estab_tl,

149: hou_cre_estab_tl.name name_cre_estab
150: --
151: From hr_all_organization_units hou_issue_estab,
152: hr_all_organization_units_tl hou_issue_estab_tl,
153: hr_all_organization_units_tl hou_cre_estab_tl,
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,

Line 154: hr_all_organization_units_tl hoi_cre_comp_tl,

150: --
151: From hr_all_organization_units hou_issue_estab,
152: hr_all_organization_units_tl hou_issue_estab_tl,
153: hr_all_organization_units_tl hou_cre_estab_tl,
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,

Line 790: l_name hr_all_organization_units_tl.name%TYPE ;

786: l_domain_code hr_organization_information.org_information2%TYPE ;
787: l_media_type hr_organization_information.org_information3%TYPE ;
788: l_address_to_use hr_organization_information.org_information4%TYPE ;
789: l_count number;
790: l_name hr_all_organization_units_tl.name%TYPE ;
791: l_value fnd_new_messages.message_text%type;
792: l_error_type hr_lookups.meaning%type;
793: l_error hr_lookups.meaning%type;
794: l_warning hr_lookups.meaning%type;

Line 803: hr_all_organization_units_tl hou_issue_estab_tl

799: hoi_issue_estab_cre.org_information2 domain_code_g01,
800: hoi_issue_estab_cre.org_information3 type_media_g01,
801: hoi_issue_estab_cre.org_information4 address_g01
802: from hr_organization_information hoi_issue_estab_cre,
803: hr_all_organization_units_tl hou_issue_estab_tl
804: where hoi_issue_estab_cre.organization_id = p_issuing_estab_id
805: and hoi_issue_estab_cre.org_information_context = 'FR_DADS_CONTACT_INFO'
806: and hou_issue_estab_tl.organization_id = p_issuing_estab_id
807: and hou_issue_estab_tl.language = userenv('LANG');

Line 941: l_name_comp hr_all_organization_units_tl.name%TYPE;

937: p_payroll_action_id IN NUMBER)
938: IS
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);

Line 948: l_name_estab hr_all_organization_units_tl.name%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);
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;

Line 960: l_name_fisc_estab hr_all_organization_units_tl.name%TYPE;

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 ;
964: l_fisc_addr_town hr_locations_all.region_3%TYPE ;

Line 973: l_cre_estab_name hr_all_organization_units_tl.name%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;
973: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;
974: l_addr_to_use hr_organization_information.org_information2%TYPE;
975: l_pension_stmt_addr hr_organization_information.org_information1%TYPE;
976: l_pension_stmt_sort1 hr_organization_information.org_information2%TYPE;
977: l_pension_stmt_sort2 hr_organization_information.org_information3%TYPE;

Line 1040: from hr_all_organization_units_tl hou_comp_tl,

1036: hoi_comp_pen_stmt.org_information1 pension_stmt_addr,
1037: hoi_comp_pen_stmt.org_information2 pension_stmt_sort1,
1038: hoi_comp_pen_stmt.org_information3 pension_stmt_sort2,
1039: 'AOO' periodicity_code_test
1040: from hr_all_organization_units_tl hou_comp_tl,
1041: hr_all_organization_units_tl hou_hq_estab_tl,
1042: hr_all_organization_units_tl hou_fisc_estab_tl,
1043: hr_all_organization_units_tl hou_cre_estab_tl,
1044: hr_organization_information hoi_comp,

Line 1041: hr_all_organization_units_tl hou_hq_estab_tl,

1037: hoi_comp_pen_stmt.org_information2 pension_stmt_sort1,
1038: hoi_comp_pen_stmt.org_information3 pension_stmt_sort2,
1039: 'AOO' periodicity_code_test
1040: from hr_all_organization_units_tl hou_comp_tl,
1041: hr_all_organization_units_tl hou_hq_estab_tl,
1042: hr_all_organization_units_tl hou_fisc_estab_tl,
1043: hr_all_organization_units_tl hou_cre_estab_tl,
1044: hr_organization_information hoi_comp,
1045: hr_organization_information hoi_comp_pen_stmt,

Line 1042: hr_all_organization_units_tl hou_fisc_estab_tl,

1038: hoi_comp_pen_stmt.org_information3 pension_stmt_sort2,
1039: 'AOO' periodicity_code_test
1040: from hr_all_organization_units_tl hou_comp_tl,
1041: hr_all_organization_units_tl hou_hq_estab_tl,
1042: hr_all_organization_units_tl hou_fisc_estab_tl,
1043: hr_all_organization_units_tl hou_cre_estab_tl,
1044: hr_organization_information hoi_comp,
1045: hr_organization_information hoi_comp_pen_stmt,
1046: hr_organization_information hoi_hq_estab,

Line 1043: hr_all_organization_units_tl hou_cre_estab_tl,

1039: 'AOO' periodicity_code_test
1040: from hr_all_organization_units_tl hou_comp_tl,
1041: hr_all_organization_units_tl hou_hq_estab_tl,
1042: hr_all_organization_units_tl hou_fisc_estab_tl,
1043: hr_all_organization_units_tl hou_cre_estab_tl,
1044: hr_organization_information hoi_comp,
1045: hr_organization_information hoi_comp_pen_stmt,
1046: hr_organization_information hoi_hq_estab,
1047: hr_organization_information hoi_fisc_estab,

Line 2068: l_estab_name hr_all_organization_units_tl.name%TYPE ;

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

Line 2086: l_name_comp hr_all_organization_units_tl.name%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
2090: select hoi_estab_comp.org_information1 SIREN_estab,

Line 2109: hr_all_organization_units_tl hou_estab_tl,

2105: --
2106: decode(hoi_sal_tax.org_information3,null, '02', '100', '02', '01') estab_salary_tax_code
2107: --
2108: from hr_all_organization_units hou_estab,
2109: hr_all_organization_units_tl hou_estab_tl,
2110: hr_organization_information hoi_estab,
2111: hr_organization_information hoi_estab_comp,
2112: hr_all_organization_units_tl hoi_estab_comp_tl,
2113: --

Line 2112: hr_all_organization_units_tl hoi_estab_comp_tl,

2108: from hr_all_organization_units hou_estab,
2109: hr_all_organization_units_tl hou_estab_tl,
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,