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_PRE_GEN_DIST_LINES_HISTORY

Line 2467: -- move the transferred records to psp_pre_gen_dist_lines_history

2463:
2464: UPDATE psp_pre_gen_dist_lines
2465: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2466:
2467: -- move the transferred records to psp_pre_gen_dist_lines_history
2468: -- Introduced DFF columns for bug fix 2908859
2469: INSERT INTO psp_pre_gen_dist_lines_history
2470: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2471: element_type_id,distribution_date,effective_date,distribution_amount,

Line 2469: INSERT INTO psp_pre_gen_dist_lines_history

2465: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2466:
2467: -- move the transferred records to psp_pre_gen_dist_lines_history
2468: -- Introduced DFF columns for bug fix 2908859
2469: INSERT INTO psp_pre_gen_dist_lines_history
2470: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2471: element_type_id,distribution_date,effective_date,distribution_amount,
2472: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
2473: batch_name,status_code,set_of_books_id,

Line 4503: -- move the transferred records to psp_pre_gen_dist_lines_history

4499: UPDATE psp_pre_gen_dist_lines
4500: SET status_code = 'A'
4501: WHERE rowid = l_rowid;
4502:
4503: -- move the transferred records to psp_pre_gen_dist_lines_history
4504: INSERT INTO psp_pre_gen_dist_lines_history
4505: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4506: element_type_id,distribution_date,effective_date,distribution_amount,
4507: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4504: INSERT INTO psp_pre_gen_dist_lines_history

4500: SET status_code = 'A'
4501: WHERE rowid = l_rowid;
4502:
4503: -- move the transferred records to psp_pre_gen_dist_lines_history
4504: INSERT INTO psp_pre_gen_dist_lines_history
4505: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4506: element_type_id,distribution_date,effective_date,distribution_amount,
4507: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4508: batch_name,status_code,set_of_books_id,

Line 4992: -- move the transferred records to psp_pre_gen_dist_lines_history

4988:
4989: UPDATE psp_pre_gen_dist_lines
4990: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4991:
4992: -- move the transferred records to psp_pre_gen_dist_lines_history
4993: INSERT INTO psp_pre_gen_dist_lines_history
4994: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4995: element_type_id,distribution_date,effective_date,distribution_amount,
4996: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4993: INSERT INTO psp_pre_gen_dist_lines_history

4989: UPDATE psp_pre_gen_dist_lines
4990: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4991:
4992: -- move the transferred records to psp_pre_gen_dist_lines_history
4993: INSERT INTO psp_pre_gen_dist_lines_history
4994: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4995: element_type_id,distribution_date,effective_date,distribution_amount,
4996: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4997: batch_name,status_code,set_of_books_id,

Line 5317: From psp_pre_gen_dist_lines_history pregen,

5313: cursor pregen_er_supercede is
5314: Select per.effort_report_id,
5315: per.person_id,
5316: min(pregen.summary_line_id)
5317: From psp_pre_gen_dist_lines_history pregen,
5318: Psp_eff_reports per,
5319: Psp_payroll_controls ppc
5320: Where pregen.distribution_date between per.start_date and per.end_date
5321: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5435: From psp_pre_gen_dist_lines_history pregen,

5431: UNION ALL
5432: Select per.effort_report_id,
5433: per.person_id,
5434: pregen.summary_line_id summary_line_id
5435: From psp_pre_gen_dist_lines_history pregen,
5436: Psp_eff_reports per,
5437: Psp_payroll_controls ppc
5438: Where pregen.distribution_date between per.start_date and per.end_date
5439: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

Line 5507: From psp_pre_gen_dist_lines_history pregen,

5503: cursor pregen_asg_er_supercede is
5504: Select per.effort_report_id,
5505: per.person_id,
5506: min(pregen.summary_line_id)
5507: From psp_pre_gen_dist_lines_history pregen,
5508: Psp_eff_reports per,
5509: Psp_payroll_controls ppc,
5510: psp_eff_report_details perd
5511: Where pregen.distribution_date between per.start_date and per.end_date

Line 5635: From psp_pre_gen_dist_lines_history pregen,

5631: UNION ALL
5632: Select per.effort_report_id,
5633: per.person_id,
5634: pregen.summary_line_id summary_line_id
5635: From psp_pre_gen_dist_lines_history pregen,
5636: Psp_eff_reports per,
5637: Psp_payroll_controls ppc,
5638: psp_eff_report_details perd
5639: Where pregen.distribution_date between per.start_date and per.end_date