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_ORGANIZATION_INFORMATION

Line 91: l_siren hr_organization_information.org_information1%TYPE ;

87: p_payroll_action_id IN NUMBER,
88: p_cre_info_issue OUT NOCOPY g_cre_info_issue%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 ;

Line 112: l_cre_estab_id hr_organization_information.organization_id%TYPE ;

108: l_live_send_code varchar2(4) ;
109: l_test_send_code varchar2(4) ;
110: l_norm varchar2(30) ;
111: l_table_code varchar2(30) ;
112: l_cre_estab_id hr_organization_information.organization_id%TYPE ;
113: l_cre_siren hr_organization_information.org_information1%TYPE ;
114: l_cre_nic varchar2(7) ;
115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%TYPE ;

Line 113: l_cre_siren hr_organization_information.org_information1%TYPE ;

109: l_test_send_code varchar2(4) ;
110: l_norm varchar2(30) ;
111: l_table_code varchar2(30) ;
112: l_cre_estab_id hr_organization_information.organization_id%TYPE ;
113: l_cre_siren hr_organization_information.org_information1%TYPE ;
114: l_cre_nic varchar2(7) ;
115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%TYPE ;
117: l_value fnd_new_messages.message_text%type;

Line 115: l_cre_media hr_organization_information.org_information1%TYPE ;

111: l_table_code varchar2(30) ;
112: l_cre_estab_id hr_organization_information.organization_id%TYPE ;
113: l_cre_siren hr_organization_information.org_information1%TYPE ;
114: l_cre_nic varchar2(7) ;
115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%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;

Line 116: l_address_to_use hr_organization_information.org_information2%TYPE ;

112: l_cre_estab_id hr_organization_information.organization_id%TYPE ;
113: l_cre_siren hr_organization_information.org_information1%TYPE ;
114: l_cre_nic varchar2(7) ;
115: l_cre_media hr_organization_information.org_information1%TYPE ;
116: l_address_to_use hr_organization_information.org_information2%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;

Line 155: hr_organization_information hoi_issue_estab_cre,

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,
159: hr_locations_all_tl hloc_issue_estab_tl,

Line 156: hr_organization_information hoi_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,
159: hr_locations_all_tl hloc_issue_estab_tl,
160: --

Line 157: hr_organization_information hoi_issue_comp,

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,
159: hr_locations_all_tl hloc_issue_estab_tl,
160: --
161: hr_organization_information hoi_cre_estab,

Line 161: hr_organization_information hoi_cre_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,
164: --
165: fnd_territories ft_issue_estab

Line 162: hr_organization_information hoi_cre_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,
164: --
165: fnd_territories ft_issue_estab
166: --

Line 163: hr_organization_information hoi_cre_dads,

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,
164: --
165: fnd_territories ft_issue_estab
166: --
167: Where hou_issue_estab.organization_id = p_param_issuing_estab_id

Line 785: l_person hr_organization_information.org_information1%TYPE ;

781: PROCEDURE S10_01_issue_person(p_issuing_estab_id IN NUMBER,
782: p_payroll_action_id IN NUMBER)
783: IS
784: --
785: l_person hr_organization_information.org_information1%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;

Line 786: l_domain_code hr_organization_information.org_information2%TYPE ;

782: p_payroll_action_id IN NUMBER)
783: IS
784: --
785: l_person hr_organization_information.org_information1%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 ;

Line 787: l_media_type hr_organization_information.org_information3%TYPE ;

783: IS
784: --
785: l_person hr_organization_information.org_information1%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;

Line 788: l_address_to_use hr_organization_information.org_information4%TYPE ;

784: --
785: l_person hr_organization_information.org_information1%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;

Line 802: from hr_organization_information hoi_issue_estab_cre,

798: hou_issue_estab_tl.name name_issue_estab,
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

Line 940: l_siren_comp hr_organization_information.org_information1%TYPE;

936: p_dads_end_date IN DATE,
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);

Line 969: l_cre_siren hr_organization_information.org_information1%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;
973: l_cre_estab_name hr_all_organization_units_tl.name%TYPE;

Line 971: l_cre_media hr_organization_information.org_information1%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;
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;

Line 972: l_cre_estab_id hr_organization_information.organization_id%TYPE;

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

Line 974: l_addr_to_use hr_organization_information.org_information2%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;
978: l_periodicity_code_live varchar2(5);

Line 975: l_pension_stmt_addr hr_organization_information.org_information1%TYPE;

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;
978: l_periodicity_code_live varchar2(5);
979: l_periodicity_code_test varchar2(5);

Line 976: l_pension_stmt_sort1 hr_organization_information.org_information2%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;
978: l_periodicity_code_live varchar2(5);
979: l_periodicity_code_test varchar2(5);
980: l_hq_estab_id hr_organization_information.organization_id%TYPE;

Line 977: l_pension_stmt_sort2 hr_organization_information.org_information3%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;
978: l_periodicity_code_live varchar2(5);
979: l_periodicity_code_test varchar2(5);
980: l_hq_estab_id hr_organization_information.organization_id%TYPE;
981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;

Line 980: l_hq_estab_id hr_organization_information.organization_id%TYPE;

976: l_pension_stmt_sort1 hr_organization_information.org_information2%TYPE;
977: l_pension_stmt_sort2 hr_organization_information.org_information3%TYPE;
978: l_periodicity_code_live varchar2(5);
979: l_periodicity_code_test varchar2(5);
980: l_hq_estab_id hr_organization_information.organization_id%TYPE;
981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;
982: l_value fnd_new_messages.message_text%type;
983: l_error_type hr_lookups.meaning%type;
984: l_error hr_lookups.meaning%type;

Line 981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;

977: l_pension_stmt_sort2 hr_organization_information.org_information3%TYPE;
978: l_periodicity_code_live varchar2(5);
979: l_periodicity_code_test varchar2(5);
980: l_hq_estab_id hr_organization_information.organization_id%TYPE;
981: l_fisc_estab_id hr_organization_information.organization_id%TYPE;
982: l_value fnd_new_messages.message_text%type;
983: l_error_type hr_lookups.meaning%type;
984: l_error hr_lookups.meaning%type;
985: l_warning hr_lookups.meaning%type;

Line 1044: hr_organization_information hoi_comp,

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,
1048: hr_all_organization_units hou_hq_estab,

Line 1045: hr_organization_information hoi_comp_pen_stmt,

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

Line 1046: hr_organization_information hoi_hq_estab,

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,
1048: hr_all_organization_units hou_hq_estab,
1049: hr_all_organization_units hou_fisc_estab,
1050: hr_locations_all hloc_hq,

Line 1047: hr_organization_information hoi_fisc_estab,

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

Line 1056: hr_organization_information hoi_cre_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
1060: and hou_comp_tl.language = userenv('LANG')

Line 1057: hr_organization_information hoi_cre_comp,

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
1060: and hou_comp_tl.language = userenv('LANG')
1061: and hoi_comp.organization_id = hou_comp_tl.organization_id

Line 1058: hr_organization_information hoi_cre_dads

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
1060: and hou_comp_tl.language = userenv('LANG')
1061: and hoi_comp.organization_id = hou_comp_tl.organization_id
1062: and hoi_comp.org_information_context = 'FR_COMP_INFO'

Line 2066: l_estab_siren hr_organization_information.org_information1%TYPE ;

2062: p_dads_end_date IN DATE)
2063: IS
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 ;

Line 2078: l_estab_salary_tax_code hr_organization_information.org_information3%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;
2081: l_error_type hr_lookups.meaning%type;
2082: l_error hr_lookups.meaning%type;

Line 2110: hr_organization_information hoi_estab,

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

Line 2111: hr_organization_information hoi_estab_comp,

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

Line 2118: hr_organization_information hoi_sal_tax

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
2121: and hou_estab_tl.organization_id = hou_estab.organization_id
2122: and hou_estab_tl.language = userenv('LANG')