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_IN_SOE dependencies on PAY_ASSIGNMENT_ACTIONS

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 1211: FROM pay_assignment_actions paa1,pay_action_interlocks intl,pay_payroll_actions ppa1

1207: AND paa.payroll_action_id = pai.action_context_id
1208: AND paa.assignment_id = nvl(pai.assignment_id,paa.assignment_id)
1209: AND EXISTS
1210: (SELECT ppa1.pay_advice_message
1211: FROM pay_assignment_actions paa1,pay_action_interlocks intl,pay_payroll_actions ppa1
1212: WHERE intl.locking_action_id = paa.assignment_action_id
1213: AND intl.locked_action_id = paa1.assignment_action_id
1214: AND paa1.payroll_action_id = ppa1.payroll_action_id
1215: AND ppa1.pay_advice_message IS NOT NULL

Line 1626: ,pay_assignment_actions paa

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
1630: AND piaav.effective_date BETWEEN :start_date

Line 2028: ,pay_assignment_actions paa

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
2032: AND piaav.effective_date BETWEEN :start_date