APPS.PAY_IN_SOE dependencies on PAY_ACTION_INFORMATION

Line 489: FROM pay_action_information pai

485:
486: CURSOR c_emp_email_id
487: IS
488: SELECT pai.action_information1
489: FROM pay_action_information pai
490: WHERE action_information_category = 'IN_EMPLOYEE_DETAILS'
491: AND action_context_id = p_assign_action_id;
492:
493: --

Line 1195: FROM pay_assignment_actions paa, pay_action_information pai

1191: IS
1192: --
1193:
1194: SELECT pai.action_information6 value
1195: FROM pay_assignment_actions paa, pay_action_information pai
1196: WHERE paa.assignment_action_id = p_action_context_id
1197: AND paa.payroll_action_id = pai.action_context_id
1198: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
1199: AND pai.action_information2 = 'MESG'

Line 1203: FROM pay_action_information pai,pay_assignment_actions paa

1199: AND pai.action_information2 = 'MESG'
1200: AND pai.jurisdiction_code IS NOT NULL
1201: UNION
1202: SELECT pai.action_information6 value
1203: FROM pay_action_information pai,pay_assignment_actions paa
1204: WHERE paa.assignment_action_id = p_action_context_id
1205: AND pai.action_information_category = 'EMPLOYEE OTHER INFORMATION'
1206: AND pai.action_information2 = 'MESG'
1207: AND paa.payroll_action_id = pai.action_context_id

Line 1625: ,pay_action_information peaiv

1621: ,peaiv.action_information1 full_name
1622: ,peaiv.action_information30 location_name
1623: ,peaiv.action_information15 organization_name
1624: FROM pay_in_arch_actions_v piaav
1625: ,pay_action_information peaiv
1626: ,pay_assignment_actions paa
1627: ,per_all_assignments_f paf
1628: WHERE piaav.business_group_id = :bg_id
1629: AND piaav.business_group_id = paf.business_group_id

Line 2027: ,pay_action_information peaiv

2023: ,peaiv.action_information1 full_name
2024: ,peaiv.action_information30 location_name
2025: ,peaiv.action_information15 organization_name
2026: FROM pay_in_arch_actions_v piaav
2027: ,pay_action_information peaiv
2028: ,pay_assignment_actions paa
2029: ,per_all_assignments_f paf
2030: WHERE piaav.business_group_id = :bg_id
2031: AND piaav.business_group_id = paf.business_group_id

Line 2043: FROM pay_action_information pai

2039: AND ( :person_id = -1 OR paf.person_id = :person_id)
2040: AND paf.assignment_id = paa.assignment_id
2041: AND peaiv.action_context_id = piaav.assignment_action_id
2042: AND EXISTS (SELECT 1
2043: FROM pay_action_information pai
2044: WHERE pai.action_information_category = ''IN_EMPLOYEE_DETAILS''
2045: AND pai.action_context_id = peaiv.action_context_id
2046: AND pai.action_information1 IS NOT NULL)
2047: AND peaiv.action_context_type = ''AAP''