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.PSP_SUM_TRANS dependencies on PSP_PAYROLL_LINES

Line 495: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (

491: DELETE FROM psp_distribution_lines
492: WHERE distribution_amount = 0
493: AND payroll_sub_line_id IN (
494: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
495: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
496: select payroll_control_id from psp_payroll_controls where payroll_control_id=
497: payroll_control_rec.payroll_control_id)));
498:
499: SELECT count(*)

Line 503: psp_payroll_lines ppl

499: SELECT count(*)
500: INTO l_line_counter
501: FROM psp_distribution_lines pdl,
502: psp_payroll_sub_lines ppsl,
503: psp_payroll_lines ppl
504: WHERE ppl.payroll_control_id = payroll_control_rec.payroll_control_id
505: AND ppl.payroll_line_id = ppsl.payroll_line_id
506: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id;
507:

Line 635: psp_payroll_lines ppl,

631: psp_organization_accounts pos,
632: psp_element_type_accounts pea,
633: psp_default_labor_schedules pdls,
634: psp_payroll_controls ppc,
635: psp_payroll_lines ppl,
636: psp_payroll_sub_lines ppsl,
637: psp_distribution_lines pdl
638: WHERE pdl.status_code = 'N'
639: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 717: psp_payroll_lines ppl,

713: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute8, pos.attribute8), NULL) attribute8,
714: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
715: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
716: FROM psp_payroll_controls ppc,
717: psp_payroll_lines ppl,
718: psp_payroll_sub_lines ppsl,
719: psp_organization_accounts pos,
720: psp_distribution_lines pdl
721: WHERE pdl.status_code = 'N'

Line 1754: psp_payroll_lines ppl,

1750: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
1751: SELECT hou.organization_id, hou.name
1752: FROM hr_all_organization_units hou,
1753: per_assignments_f paf,
1754: psp_payroll_lines ppl,
1755: psp_payroll_sub_lines ppsl,
1756: psp_distribution_lines pdl
1757: WHERE pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
1758: AND ppsl.payroll_line_id = ppl.payroll_line_id

Line 1876: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943

1872: l_person_name varchar2(300);
1873: l_account varchar2(1000);
1874: l_auto_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1875:
1876: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
1877:
1878: cursor get_element_type is
1879: select ppl.element_type_id,
1880: ppl.assignment_id,

Line 1882: from psp_payroll_lines ppl,

1878: cursor get_element_type is
1879: select ppl.element_type_id,
1880: ppl.assignment_id,
1881: ppl.person_id
1882: from psp_payroll_lines ppl,
1883: psp_payroll_sub_lines ppsl,
1884: psp_distribution_lines pdl
1885: where pdl.distribution_line_id = x_line_id
1886: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 2011: FROM psp_payroll_lines

2007:
2008: -- Bug 7376898
2009: SELECT payroll_action_type
2010: INTO l_pay_action_type
2011: FROM psp_payroll_lines
2012: WHERE payroll_control_id = p_payroll_control_id
2013: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
2014: where payroll_sub_line_id = (select payroll_sub_line_id
2015: from psp_distribution_lines

Line 2569: psp_payroll_lines ppl,

2565: pdl.business_group_id,
2566: pdl.set_of_books_id
2567: FROM psp_distribution_lines pdl,
2568: psp_payroll_sub_lines ppsl,
2569: psp_payroll_lines ppl,
2570: psp_payroll_controls ppc
2571: WHERE ppc.payroll_control_id = p_payroll_control_id
2572: AND ppc.payroll_control_id = ppl.payroll_control_id
2573: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 2629: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (

2625: WHERE reversal_entry_flag = 'Y'
2626: AND status_code = 'N'
2627: AND payroll_sub_line_id IN (
2628: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
2629: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
2630: select payroll_control_id from psp_payroll_controls where payroll_control_id=
2631: p_payroll_control_id)));
2632:
2633:

Line 2661: psp_payroll_lines ppl,

2657: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount)) dr_amount
2658: INTO l_cr_amount, l_dr_amount
2659: FROM psp_distribution_lines pdl,
2660: psp_payroll_sub_lines ppsl,
2661: psp_payroll_lines ppl,
2662: psp_payroll_controls ppc
2663: WHERE ppc.payroll_control_id = p_payroll_control_id
2664: AND ppc.payroll_control_id = ppl.payroll_control_id
2665: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 3021: psp_payroll_lines ppl,

3017: psp_organization_accounts pos,
3018: psp_element_type_accounts pea,
3019: psp_default_labor_schedules pdls,
3020: psp_payroll_controls ppc,
3021: psp_payroll_lines ppl,
3022: psp_payroll_sub_lines ppsl,
3023: psp_distribution_lines pdl
3024: WHERE pdl.status_code = 'N'
3025: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 3114: psp_payroll_lines ppl,

3110: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3111: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3112: FROM psp_organization_accounts pos,
3113: psp_payroll_controls ppc,
3114: psp_payroll_lines ppl,
3115: psp_payroll_sub_lines ppsl,
3116: psp_distribution_lines pdl
3117: WHERE pdl.status_code = 'N'
3118: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 4095: psp_payroll_lines ppl,

4091: CURSOR get_org_id_cur1 (P_LINE_ID IN NUMBER) IS
4092: SELECT hou.organization_id, hou.name
4093: FROM hr_all_organization_units hou,
4094: per_assignments_f paf,
4095: psp_payroll_lines ppl,
4096: psp_payroll_sub_lines ppsl,
4097: psp_distribution_lines pdl
4098: WHERE paf.assignment_id = ppl.assignment_id
4099: AND hou.organization_id = paf.organization_id

Line 4217: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943

4213: l_element_type varchar2(200);
4214: l_person_name varchar2(300);
4215: l_account varchar2(1000);
4216: l_auto_org_name hr_all_organization_units_tl.name%TYPE;
4217: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
4218:
4219: cursor get_element_type is
4220: select ppl.element_type_id,
4221: ppl.assignment_id,

Line 4223: from psp_payroll_lines ppl,

4219: cursor get_element_type is
4220: select ppl.element_type_id,
4221: ppl.assignment_id,
4222: ppl.person_id
4223: from psp_payroll_lines ppl,
4224: psp_payroll_sub_lines ppsl,
4225: psp_distribution_lines pdl
4226: where pdl.distribution_line_id = x_line_id
4227: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 4429: FROM psp_payroll_lines

4425:
4426: /*Bug 7376898*/
4427: SELECT distinct payroll_action_type
4428: INTO l_pay_action_type
4429: FROM psp_payroll_lines
4430: WHERE payroll_control_id = p_payroll_control_id
4431: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
4432: where payroll_sub_line_id = (select payroll_sub_line_id
4433: from psp_distribution_lines

Line 4437: FROM psp_payroll_lines

4433: from psp_distribution_lines
4434: where distribution_line_id = x_line_id));
4435: SELECT distinct effective_date
4436: INTO l_effective_date
4437: FROM psp_payroll_lines
4438: WHERE payroll_control_id = p_payroll_control_id
4439: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
4440: where payroll_sub_line_id = (select payroll_sub_line_id
4441: from psp_distribution_lines

Line 5357: psp_payroll_lines ppl

5353: From psp_eff_reports per,
5354: Psp_distribution_lines_history DLH,
5355: Psp_payroll_controls ppc,
5356: psp_payroll_sub_lines psub,
5357: psp_payroll_lines ppl
5358: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5359: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5360: And psub.payroll_line_id = ppl.payroll_line_id
5361: And ppl.person_id = per.person_id

Line 5401: psp_payroll_lines ppl

5397: From psp_eff_reports per,
5398: Psp_distribution_lines_history DLH,
5399: Psp_payroll_controls ppc,
5400: psp_payroll_sub_lines psub,
5401: psp_payroll_lines ppl
5402: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5403: And per.request_id in (select -person_id from psp_supercede_persons_gt)
5404: And psub.payroll_line_id = ppl.payroll_line_id
5405: And ppl.person_id = per.person_id

Line 5550: psp_payroll_lines ppl,

5546: From psp_eff_reports per,
5547: Psp_distribution_lines_history DLH,
5548: Psp_payroll_controls ppc,
5549: psp_payroll_sub_lines psub,
5550: psp_payroll_lines ppl,
5551: psp_eff_report_details perd
5552: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5553: and perd.effort_report_id = per.effort_report_id
5554: and perd.assignment_id = ppl.assignment_id

Line 5598: psp_payroll_lines ppl,

5594: From psp_eff_reports per,
5595: Psp_distribution_lines_history DLH,
5596: Psp_payroll_controls ppc,
5597: psp_payroll_sub_lines psub,
5598: psp_payroll_lines ppl,
5599: psp_eff_report_details perd
5600: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5601: and perd.effort_report_id = per.effort_report_id
5602: and perd.assignment_id = ppl.assignment_id