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 550: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (

546: DELETE FROM psp_distribution_lines
547: WHERE distribution_amount = 0
548: AND payroll_sub_line_id IN (
549: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
550: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
551: select payroll_control_id from psp_payroll_controls where payroll_control_id=
552: payroll_control_rec.payroll_control_id)));
553:
554: SELECT count(*)

Line 558: psp_payroll_lines ppl

554: SELECT count(*)
555: INTO l_line_counter
556: FROM psp_distribution_lines pdl,
557: psp_payroll_sub_lines ppsl,
558: psp_payroll_lines ppl
559: WHERE ppl.payroll_control_id = payroll_control_rec.payroll_control_id
560: AND ppl.payroll_line_id = ppsl.payroll_line_id
561: AND ppsl.payroll_sub_line_id = pdl.payroll_sub_line_id;
562:

Line 692: psp_payroll_lines ppl,

688: psp_organization_accounts pos,
689: psp_element_type_accounts pea,
690: psp_default_labor_schedules pdls,
691: psp_payroll_controls ppc,
692: psp_payroll_lines ppl,
693: psp_payroll_sub_lines ppsl,
694: psp_distribution_lines pdl
695: WHERE pdl.status_code = 'N'
696: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 774: psp_payroll_lines ppl,

770: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute8, pos.attribute8), NULL) attribute8,
771: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute9, pos.attribute9), NULL) attribute9,
772: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
773: FROM psp_payroll_controls ppc,
774: psp_payroll_lines ppl,
775: psp_payroll_sub_lines ppsl,
776: psp_organization_accounts pos,
777: psp_distribution_lines pdl
778: WHERE pdl.status_code = 'N'

Line 1864: psp_payroll_lines ppl,

1860: CURSOR get_org_id_cur(P_LINE_ID IN NUMBER) IS
1861: SELECT hou.organization_id, hou.name
1862: FROM hr_all_organization_units hou,
1863: per_assignments_f paf,
1864: psp_payroll_lines ppl,
1865: psp_payroll_sub_lines ppsl,
1866: psp_distribution_lines pdl
1867: WHERE pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id
1868: AND ppsl.payroll_line_id = ppl.payroll_line_id

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

1982: l_person_name varchar2(300);
1983: l_account varchar2(1000);
1984: l_auto_org_name hr_all_organization_units_tl.name%TYPE; -- Bug 2447912: Modified declaration
1985:
1986: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
1987:
1988: cursor get_element_type is
1989: select ppl.element_type_id,
1990: ppl.assignment_id,

Line 1992: from psp_payroll_lines ppl,

1988: cursor get_element_type is
1989: select ppl.element_type_id,
1990: ppl.assignment_id,
1991: ppl.person_id
1992: from psp_payroll_lines ppl,
1993: psp_payroll_sub_lines ppsl,
1994: psp_distribution_lines pdl
1995: where pdl.distribution_line_id = x_line_id
1996: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 2142: FROM psp_payroll_lines

2138: IF p_source_type IN('O', 'N') THEN
2139: -- Bug 7376898
2140: SELECT payroll_action_type
2141: INTO l_pay_action_type
2142: FROM psp_payroll_lines
2143: WHERE payroll_control_id = p_payroll_control_id
2144: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
2145: where payroll_sub_line_id = (select payroll_sub_line_id
2146: from psp_distribution_lines

Line 2747: psp_payroll_lines ppl,

2743: pdl.business_group_id,
2744: pdl.set_of_books_id
2745: FROM psp_distribution_lines pdl,
2746: psp_payroll_sub_lines ppsl,
2747: psp_payroll_lines ppl,
2748: psp_payroll_controls ppc
2749: WHERE ppc.payroll_control_id = p_payroll_control_id
2750: AND ppc.payroll_control_id = ppl.payroll_control_id
2751: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 2807: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (

2803: WHERE reversal_entry_flag = 'Y'
2804: AND status_code = 'N'
2805: AND payroll_sub_line_id IN (
2806: select payroll_sub_line_id from psp_payroll_sub_lines where payroll_line_id IN (
2807: select payroll_line_id from psp_payroll_lines where payroll_control_id IN (
2808: select payroll_control_id from psp_payroll_controls where payroll_control_id=
2809: p_payroll_control_id)));
2810:
2811:

Line 2839: psp_payroll_lines ppl,

2835: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount)) dr_amount
2836: INTO l_cr_amount, l_dr_amount
2837: FROM psp_distribution_lines pdl,
2838: psp_payroll_sub_lines ppsl,
2839: psp_payroll_lines ppl,
2840: psp_payroll_controls ppc
2841: WHERE ppc.payroll_control_id = p_payroll_control_id
2842: AND ppc.payroll_control_id = ppl.payroll_control_id
2843: AND ppl.payroll_line_id = ppsl.payroll_line_id

Line 3203: psp_payroll_lines ppl,

3199: psp_organization_accounts pos,
3200: psp_element_type_accounts pea,
3201: psp_default_labor_schedules pdls,
3202: psp_payroll_controls ppc,
3203: psp_payroll_lines ppl,
3204: psp_payroll_sub_lines ppsl,
3205: psp_distribution_lines pdl
3206: WHERE pdl.status_code = 'N'
3207: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 3296: psp_payroll_lines ppl,

3292: DECODE(g_dff_grouping_option, 'Y', DECODE(pdl.suspense_org_account_id, NULL, pdl.attribute10, pos.attribute10), NULL) attribute10
3293: ---decode(pdl.suspense_org_account_id, NULL, 'N', 'Y') Suspense_Flag uncommented for 2663344
3294: FROM psp_organization_accounts pos,
3295: psp_payroll_controls ppc,
3296: psp_payroll_lines ppl,
3297: psp_payroll_sub_lines ppsl,
3298: psp_distribution_lines pdl
3299: WHERE pdl.status_code = 'N'
3300: AND pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 4358: psp_payroll_lines ppl,

4354: CURSOR get_org_id_cur1 (P_LINE_ID IN NUMBER) IS
4355: SELECT hou.organization_id, hou.name
4356: FROM hr_all_organization_units hou,
4357: per_assignments_f paf,
4358: psp_payroll_lines ppl,
4359: psp_payroll_sub_lines ppsl,
4360: psp_distribution_lines pdl
4361: WHERE paf.assignment_id = ppl.assignment_id
4362: AND hou.organization_id = paf.organization_id

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

4476: l_element_type varchar2(200);
4477: l_person_name varchar2(300);
4478: l_account varchar2(1000);
4479: l_auto_org_name hr_all_organization_units_tl.name%TYPE;
4480: l_pay_action_type psp_payroll_lines.payroll_action_type%TYPE; -- Bug 7040943
4481:
4482: cursor get_element_type is
4483: select ppl.element_type_id,
4484: ppl.assignment_id,

Line 4486: from psp_payroll_lines ppl,

4482: cursor get_element_type is
4483: select ppl.element_type_id,
4484: ppl.assignment_id,
4485: ppl.person_id
4486: from psp_payroll_lines ppl,
4487: psp_payroll_sub_lines ppsl,
4488: psp_distribution_lines pdl
4489: where pdl.distribution_line_id = x_line_id
4490: and pdl.payroll_sub_line_id = ppsl.payroll_sub_line_id

Line 4743: FROM psp_payroll_lines

4739: IF p_source_type IN('O', 'N') THEN
4740: /*Bug 7376898*/
4741: SELECT payroll_action_type, effective_date
4742: INTO l_pay_action_type, l_effective_date
4743: FROM psp_payroll_lines
4744: WHERE payroll_control_id = p_payroll_control_id
4745: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
4746: where payroll_sub_line_id = (select payroll_sub_line_id
4747: from psp_distribution_lines

Line 4749: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' from psp_payroll_lines: l_pay_action_type, l_effective_date'||l_pay_action_type||l_effective_date);

4745: and payroll_line_id = (select payroll_line_id from psp_payroll_sub_lines
4746: where payroll_sub_line_id = (select payroll_sub_line_id
4747: from psp_distribution_lines
4748: where distribution_line_id = x_line_id));
4749: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' from psp_payroll_lines: l_pay_action_type, l_effective_date'||l_pay_action_type||l_effective_date);
4750:
4751: /*Bug 7376898 End*/
4752: END IF;
4753:

Line 5780: psp_payroll_lines ppl

5776: From psp_eff_reports per,
5777: Psp_distribution_lines_history DLH,
5778: Psp_payroll_controls ppc,
5779: psp_payroll_sub_lines psub,
5780: psp_payroll_lines ppl
5781: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5782: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5783: And psub.payroll_line_id = ppl.payroll_line_id
5784: And ppl.person_id = per.person_id

Line 5824: psp_payroll_lines ppl

5820: From psp_eff_reports per,
5821: Psp_distribution_lines_history DLH,
5822: Psp_payroll_controls ppc,
5823: psp_payroll_sub_lines psub,
5824: psp_payroll_lines ppl
5825: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5826: And per.request_id in (select -person_id from psp_supercede_persons_gt)
5827: And psub.payroll_line_id = ppl.payroll_line_id
5828: And ppl.person_id = per.person_id

Line 5973: psp_payroll_lines ppl,

5969: From psp_eff_reports per,
5970: Psp_distribution_lines_history DLH,
5971: Psp_payroll_controls ppc,
5972: psp_payroll_sub_lines psub,
5973: psp_payroll_lines ppl,
5974: psp_eff_report_details perd
5975: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5976: and perd.effort_report_id = per.effort_report_id
5977: and perd.assignment_id = ppl.assignment_id

Line 6021: psp_payroll_lines ppl,

6017: From psp_eff_reports per,
6018: Psp_distribution_lines_history DLH,
6019: Psp_payroll_controls ppc,
6020: psp_payroll_sub_lines psub,
6021: psp_payroll_lines ppl,
6022: psp_eff_report_details perd
6023: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
6024: and perd.effort_report_id = per.effort_report_id
6025: and perd.assignment_id = ppl.assignment_id