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 1187: ,pay_assignment_actions paa

1183: AND action_information2 = p_assess_year
1184: AND action_information3 = p_gre_org_id
1185: AND action_context_id IN ( SELECT MAX(action_context_id)
1186: FROM pay_action_information pai
1187: ,pay_assignment_actions paa
1188: ,per_assignments_f asg
1189: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1190: AND pai.action_context_type = 'AAP'
1191: AND pai.action_information2 = p_assess_year

Line 1213: ,pay_assignment_actions paa

1209: CURSOR csr_get_max_cont_id IS
1210: SELECT MAX(pai.action_context_id) action_cont_id
1211: ,source_id sour_id
1212: FROM pay_action_information pai
1213: ,pay_assignment_actions paa
1214: ,per_assignments_f asg
1215: WHERE pai.action_information_category = 'IN_EOY_PERSON'
1216: AND pai.action_information3 = p_gre_org_id
1217: AND pai.action_information2 = p_assess_year

Line 1419: ,pay_assignment_actions paa

1415: substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) member_id
1416: ,count(DISTINCT paa_asg.action_information4) asg_cnt
1417: FROM pay_action_information paa_asg
1418: ,pay_action_information paa_pay
1419: ,pay_assignment_actions paa
1420: WHERE paa_asg.action_information_category='IN_PF_ASG'
1421: AND paa_pay.action_information_category='IN_PF_PAY'
1422: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
1423: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 1447: ,pay_assignment_actions paa

1443: DISTINCT substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) member_id
1444: ,paa_asg.action_information4 member_name
1445: FROM pay_action_information paa_asg
1446: ,pay_action_information paa_pay
1447: ,pay_assignment_actions paa
1448: WHERE paa_asg.action_information_category='IN_PF_ASG'
1449: AND paa_pay.action_information_category='IN_PF_PAY'
1450: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
1451: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 1490: ,pay_assignment_actions paa

1486: ,paa_asg.action_information26 term_reason
1487: ,to_char(to_date(paa_asg.action_information13,'DD/MM/RRRR'),'DD/MM/RRRR') payroll_date
1488: FROM pay_action_information paa_asg
1489: ,pay_action_information paa_pay
1490: ,pay_assignment_actions paa
1491: WHERE paa_asg.action_information_category='IN_PF_ASG'
1492: AND paa_pay.action_information_category='IN_PF_PAY'
1493: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
1494: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 2083: ,pay_assignment_actions paa

2079: ,paa_pay.action_information6 --Code
2080: ,paa_pay.action_information8 --PF Org Name
2081: FROM pay_action_information paa_asg
2082: ,pay_action_information paa_pay
2083: ,pay_assignment_actions paa
2084: ,hr_organization_units hou
2085: WHERE paa_asg.action_information_category = 'IN_PF_ASG'
2086: AND paa_pay.action_information_category = 'IN_PF_PAY'
2087: AND paa_asg.ACTION_CONTEXT_TYPE = 'AAP'

Line 2216: ,pay_assignment_actions paa

2212: IS
2213: SELECT paa_pay.action_information4 rep_name
2214: FROM pay_action_information paa_asg
2215: ,pay_action_information paa_pay
2216: ,pay_assignment_actions paa
2217: WHERE paa_asg.action_information_category='IN_PF_ASG'
2218: AND paa_pay.action_information_category='IN_PF_PAY'
2219: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
2220: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3140: ,pay_assignment_actions paa

3136: ,paa_pay.action_information6 --Code
3137: ,paa_pay.action_information8 --PF Org Name
3138: FROM pay_action_information paa_asg
3139: ,pay_action_information paa_pay
3140: ,pay_assignment_actions paa
3141: ,hr_organization_units hou
3142: WHERE paa_asg.action_information_category='IN_PF_ASG'
3143: AND paa_pay.action_information_category='IN_PF_PAY'
3144: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 3298: ,pay_assignment_actions paa

3294: IS
3295: SELECT paa_pay.action_information4 rep_name
3296: FROM pay_action_information paa_asg
3297: ,pay_action_information paa_pay
3298: ,pay_assignment_actions paa
3299: WHERE paa_asg.action_information_category ='IN_PF_ASG'
3300: AND paa_pay.action_information_category ='IN_PF_PAY'
3301: AND paa_asg.ACTION_CONTEXT_TYPE ='AAP'
3302: AND paa_pay.ACTION_CONTEXT_TYPE ='PA'

Line 3802: ,pay_assignment_actions paa

3798: ,paa_asg.action_information2 pf_org_id --PF Org ID
3799: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
3800: FROM pay_action_information paa_asg
3801: ,pay_action_information paa_pay
3802: ,pay_assignment_actions paa
3803: ,hr_organization_units hou
3804: WHERE paa_asg.action_information_category='IN_PF_ASG'
3805: AND paa_pay.action_information_category='IN_PF_PAY'
3806: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 3838: ,pay_assignment_actions paa

3834: SELECT DISTINCT paa_pay.action_information5 --Address
3835: ,paa_pay.action_information3 reg --Registered Name
3836: FROM pay_action_information paa_asg
3837: ,pay_action_information paa_pay
3838: ,pay_assignment_actions paa
3839: WHERE paa_asg.action_information_category='IN_PF_ASG'
3840: AND paa_pay.action_information_category='IN_PF_PAY'
3841: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3842: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 3896: ,pay_assignment_actions paa

3892: ,paa_asg.action_information13 --Payroll Month
3893: ,paa_asg.assignment_id --Assignment ID
3894: FROM pay_action_information paa_asg
3895: ,pay_action_information paa_pay
3896: ,pay_assignment_actions paa
3897: WHERE paa_asg.action_information_category='IN_PF_ASG'
3898: AND paa_pay.action_information_category='IN_PF_PAY'
3899: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'
3900: AND paa_pay.ACTION_CONTEXT_TYPE='PA'

Line 4010: ,pay_assignment_actions paa

4006: ,paa_asg.action_information2 pf_org_id --PF Org ID
4007: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
4008: FROM pay_action_information paa_asg
4009: ,pay_action_information paa_pay
4010: ,pay_assignment_actions paa
4011: ,hr_organization_units hou
4012: WHERE paa_asg.action_information_category='IN_PF_ASG'
4013: AND paa_pay.action_information_category='IN_PF_PAY'
4014: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 4041: ,pay_assignment_actions paa

4037: ,paa_asg.action_information2 pf_org_id --PF Org ID
4038: ,substr(paa_asg.action_information3 ,instr(paa_asg.action_information3,'/',-1)+1 ) pf_acc
4039: FROM pay_action_information paa_asg
4040: ,pay_action_information paa_pay
4041: ,pay_assignment_actions paa
4042: ,hr_organization_units hou
4043: WHERE paa_asg.action_information_category='IN_PF_ASG'
4044: AND paa_pay.action_information_category='IN_PF_PAY'
4045: AND paa_asg.ACTION_CONTEXT_TYPE='AAP'

Line 4377: ,pay_assignment_actions paa

4373: ,paa_pay.action_information5 Address
4374: ,paa_pay.action_information6 Code
4375: FROM pay_action_information paa_asg
4376: ,pay_action_information paa_pay
4377: ,pay_assignment_actions paa
4378: WHERE paa_asg.action_information_category='IN_PF_ASG'
4379: AND paa_pay.action_information_category='IN_PF_PAY'
4380: AND paa_asg.action_context_type='AAP'
4381: AND paa_pay.action_context_type='PA'

Line 5271: ,pay_assignment_actions pac

5267: CURSOR c_max_pa_action_id(p_esi_org_id VARCHAR2)
5268: IS
5269: SELECT max(pai.action_context_id)
5270: FROM pay_action_information pai
5271: ,pay_assignment_actions pac
5272: WHERE pai.action_information_category='IN_ESI_PAY'
5273: AND pai.action_context_type='PA'
5274: AND pai.action_information1=p_contribution_period
5275: AND pai.action_information2=p_esi_org_id