APPS.PER_MX_SS_AFFILIATION dependencies on HR_ORGANIZATION_INFORMATION

Line 186: FROM hr_organization_information

182: ORDER BY payroll_action_id DESC;
183:
184: CURSOR c_get_imp_date (cp_organization_id NUMBER) IS
185: SELECT org_information6
186: FROM hr_organization_information
187: WHERE org_information_context = 'MX_TAX_REGISTRATION'
188: AND organization_id = cp_organization_id;
189:
190: CURSOR c_get_bus_grp_id IS

Line 264: FROM hr_organization_information

260: WHERE ppa.payroll_action_id = p_payroll_action_id;
261:
262: CURSOR csr_gre IS
263: SELECT organization_id
264: FROM hr_organization_information
265: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
266: AND org_information3 = 'N'
267: AND org_information6 = g_trans_gre_id;
268:

Line 377: FROM hr_organization_information

373: soft_coding_keyflex_id,
374: fnd_date.canonical_to_date('''||
375: g_end_date||''')) IN
376: (SELECT organization_id
377: FROM hr_organization_information
378: WHERE org_information_context = ''MX_SOC_SEC_DETAILS''
379: AND (org_information3 = ''N''
380: AND org_information6 = '|| g_trans_gre_id ||'
381: OR organization_id = '||g_trans_gre_id||'))

Line 971: FROM hr_organization_information

967: '02', 3);
968:
969: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
970: SELECT org_information6
971: FROM hr_organization_information
972: WHERE org_information_context = 'MX_TAX_REGISTRATION'
973: AND organization_id = cp_gre_id;
974:
975: