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.

[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on PSP_DISTRIBUTION_LINES_HISTORY

Line 2424: -- move the transferred records to psp_distribution_lines_history

2420:
2421: UPDATE psp_distribution_lines
2422: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2423:
2424: -- move the transferred records to psp_distribution_lines_history
2425: INSERT INTO psp_distribution_lines_history
2426: (distribution_line_id,payroll_sub_line_id,distribution_date,
2427: effective_date,distribution_amount,status_code,suspense_reason_code,
2428: effort_report_id,version_num,schedule_line_id,

Line 2425: INSERT INTO psp_distribution_lines_history

2421: UPDATE psp_distribution_lines
2422: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2423:
2424: -- move the transferred records to psp_distribution_lines_history
2425: INSERT INTO psp_distribution_lines_history
2426: (distribution_line_id,payroll_sub_line_id,distribution_date,
2427: effective_date,distribution_amount,status_code,suspense_reason_code,
2428: effort_report_id,version_num,schedule_line_id,
2429: summary_line_id,default_org_account_id,suspense_org_account_id,

Line 4458: INSERT INTO psp_distribution_lines_history

4454: UPDATE psp_distribution_lines
4455: SET status_code = 'A'
4456: WHERE rowid = l_rowid;
4457:
4458: INSERT INTO psp_distribution_lines_history
4459: (distribution_line_id,payroll_sub_line_id,distribution_date,
4460: effective_date,distribution_amount,status_code,suspense_reason_code,
4461: effort_report_id,version_num,schedule_line_id,summary_line_id,
4462: default_org_account_id,suspense_org_account_id,

Line 4949: -- move the transferred records to psp_distribution_lines_history

4945:
4946: UPDATE psp_distribution_lines
4947: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4948:
4949: -- move the transferred records to psp_distribution_lines_history
4950: INSERT INTO psp_distribution_lines_history
4951: (distribution_line_id,payroll_sub_line_id,distribution_date,
4952: effective_date,distribution_amount,status_code,suspense_reason_code,
4953: effort_report_id,version_num,schedule_line_id,summary_line_id,

Line 4950: INSERT INTO psp_distribution_lines_history

4946: UPDATE psp_distribution_lines
4947: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4948:
4949: -- move the transferred records to psp_distribution_lines_history
4950: INSERT INTO psp_distribution_lines_history
4951: (distribution_line_id,payroll_sub_line_id,distribution_date,
4952: effective_date,distribution_amount,status_code,suspense_reason_code,
4953: effort_report_id,version_num,schedule_line_id,summary_line_id,
4954: default_org_account_id,suspense_org_account_id,

Line 5354: Psp_distribution_lines_history DLH,

5350: Select per.effort_report_id,
5351: per.person_id,
5352: MIN(dlh.summary_line_id) summary_line_id
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

Line 5398: Psp_distribution_lines_history DLH,

5394: Select per.effort_report_id,
5395: per.person_id,
5396: dlh.summary_line_id summary_line_id
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

Line 5547: Psp_distribution_lines_history DLH,

5543: Select per.effort_report_id,
5544: per.person_id,
5545: MIN(dlh.summary_line_id) summary_line_id
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

Line 5595: Psp_distribution_lines_history DLH,

5591: Select per.effort_report_id,
5592: per.person_id,
5593: dlh.summary_line_id summary_line_id
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