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

Line 430: ,pay_assignment_actions pac

426: ,p_period_end DATE)
427: IS
428: SELECT MAX(pai.action_context_id)
429: FROM pay_action_information pai
430: ,pay_assignment_actions pac
431: WHERE pai.action_information_category = 'IN_PT_PAY'
432: AND pai.action_context_type = 'PA'
433: AND pai.source_id = p_pt_org_id
434: AND pac.payroll_action_id = pai.action_context_id

Line 1107: ,pay_assignment_actions paa

1103: AND action_information2 = p_assess_year
1104: AND action_information3 = p_gre_org_id
1105: AND action_context_id IN ( SELECT MAX(action_context_id)
1106: FROM pay_action_information pai
1107: ,pay_assignment_actions paa
1108: ,per_assignments_f asg
1109: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1110: AND pai.action_context_type = 'AAP'
1111: AND pai.action_information2 = p_assess_year

Line 1133: ,pay_assignment_actions paa

1129: CURSOR csr_get_max_cont_id IS
1130: SELECT MAX(pai.action_context_id) action_cont_id
1131: ,source_id sour_id
1132: FROM pay_action_information pai
1133: ,pay_assignment_actions paa
1134: ,per_assignments_f asg
1135: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1136: AND pai.action_information3 = p_gre_org_id
1137: AND pai.action_information2 = p_assess_year

Line 1502: ,pay_assignment_actions paa

1498: ,paa_pay.action_information6 --Code
1499: ,paa_pay.action_information8 --PF Org Name
1500: FROM pay_action_information paa_asg
1501: ,pay_action_information paa_pay
1502: ,pay_assignment_actions paa
1503: ,hr_organization_units hou
1504: WHERE paa_asg.action_information_category = 'IN_PF_ASG'
1505: AND paa_pay.action_information_category = 'IN_PF_PAY'
1506: AND paa_asg.ACTION_CONTEXT_TYPE = 'AAP'

Line 1635: ,pay_assignment_actions paa

1631: IS
1632: SELECT paa_pay.action_information4 rep_name
1633: FROM pay_action_information paa_asg
1634: ,pay_action_information paa_pay
1635: ,pay_assignment_actions paa
1636: WHERE paa_asg.action_information_category='IN_PF_ASG'
1637: AND paa_pay.action_information_category='IN_PF_PAY'
1638: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
1639: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 2552: ,pay_assignment_actions paa

2548: ,paa_pay.action_information6 --Code
2549: ,paa_pay.action_information8 --PF Org Name
2550: FROM pay_action_information paa_asg
2551: ,pay_action_information paa_pay
2552: ,pay_assignment_actions paa
2553: ,hr_organization_units hou
2554: WHERE paa_asg.action_information_category='IN_PF_ASG'
2555: AND paa_pay.action_information_category='IN_PF_PAY'
2556: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 2709: ,pay_assignment_actions paa

2705: IS
2706: SELECT paa_pay.action_information4 rep_name
2707: FROM pay_action_information paa_asg
2708: ,pay_action_information paa_pay
2709: ,pay_assignment_actions paa
2710: WHERE paa_asg.action_information_category ='IN_PF_ASG'
2711: AND paa_pay.action_information_category ='IN_PF_PAY'
2712: AND paa_asg.ACTION_CONTEXT_TYPE ='AAP'
2713: AND paa_pay.ACTION_CONTEXT_TYPE ='PA'

Line 3161: ,pay_assignment_actions paa

3157: ,paa_asg.action_information3 pf_num --PF Number
3158: ,paa_asg.action_information2 pf_org_id --PF Org ID
3159: FROM pay_action_information paa_asg
3160: ,pay_action_information paa_pay
3161: ,pay_assignment_actions paa
3162: ,hr_organization_units hou
3163: WHERE paa_asg.action_information_category='IN_PF_ASG'
3164: AND paa_pay.action_information_category='IN_PF_PAY'
3165: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 3197: ,pay_assignment_actions paa

3193: SELECT DISTINCT paa_pay.action_information5 --Address
3194: ,paa_pay.action_information3 reg --Registered Name
3195: FROM pay_action_information paa_asg
3196: ,pay_action_information paa_pay
3197: ,pay_assignment_actions paa
3198: WHERE paa_asg.action_information_category='IN_PF_ASG'
3199: AND paa_pay.action_information_category='IN_PF_PAY'
3200: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3201: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3255: ,pay_assignment_actions paa

3251: ,paa_asg.action_information13 --Payroll Month
3252: ,paa_asg.assignment_id --Assignment ID
3253: FROM pay_action_information paa_asg
3254: ,pay_action_information paa_pay
3255: ,pay_assignment_actions paa
3256: WHERE paa_asg.action_information_category='IN_PF_ASG'
3257: AND paa_pay.action_information_category='IN_PF_PAY'
3258: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3259: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3658: ,pay_assignment_actions paa

3654: ,paa_pay.action_information5 Address
3655: ,paa_pay.action_information6 Code
3656: FROM pay_action_information paa_asg
3657: ,pay_action_information paa_pay
3658: ,pay_assignment_actions paa
3659: WHERE paa_asg.action_information_category='IN_PF_ASG'
3660: AND paa_pay.action_information_category='IN_PF_PAY'
3661: AND paa_asg.action_context_type='AAP'
3662: AND paa_pay.action_context_type='PA'

Line 4552: ,pay_assignment_actions pac

4548: CURSOR c_max_pa_action_id(p_esi_org_id VARCHAR2)
4549: IS
4550: SELECT max(pai.action_context_id)
4551: FROM pay_action_information pai
4552: ,pay_assignment_actions pac
4553: WHERE pai.action_information_category='IN_ESI_PAY'
4554: AND pai.action_context_type='PA'
4555: AND pai.action_information1=p_contribution_period
4556: AND pai.action_information2=p_esi_org_id