APPS.PER_MX_SS_AFFILIATION dependencies on HR_ORGANIZATION_INFORMATION

Line 205: FROM hr_organization_information

201: ORDER BY payroll_action_id DESC;
202:
203: CURSOR c_get_imp_date (cp_organization_id NUMBER) IS
204: SELECT org_information6
205: FROM hr_organization_information
206: WHERE org_information_context = 'MX_TAX_REGISTRATION'
207: AND organization_id = cp_organization_id;
208:
209: CURSOR c_get_bus_grp_id IS

Line 283: FROM hr_organization_information

279: WHERE ppa.payroll_action_id = p_payroll_action_id;
280:
281: CURSOR csr_gre IS
282: SELECT organization_id
283: FROM hr_organization_information
284: WHERE org_information_context = 'MX_SOC_SEC_DETAILS'
285: AND org_information3 = 'N'
286: AND org_information6 = g_trans_gre_id;
287:

Line 406: FROM hr_organization_information

402: soft_coding_keyflex_id,
403: fnd_date.canonical_to_date('''||
404: l_new_end_date||''')) IN
405: (SELECT organization_id
406: FROM hr_organization_information
407: WHERE org_information_context = ''MX_SOC_SEC_DETAILS''
408: AND (org_information3 = ''N''
409: AND org_information6 = '|| g_trans_gre_id ||'
410: OR organization_id = '||g_trans_gre_id||'))

Line 1127: FROM hr_organization_information

1123: '02', 3);
1124:
1125: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS
1126: SELECT org_information6
1127: FROM hr_organization_information
1128: WHERE org_information_context = 'MX_TAX_REGISTRATION'
1129: AND organization_id = cp_gre_id;
1130:
1131: