APPS.PSP_SUM_TRANS dependencies on PSP_PRE_GEN_DIST_LINES_HISTORY

Line 2637: -- move the transferred records to psp_pre_gen_dist_lines_history

2633: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2634: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' 4 updated psp_pre_gen_distribution_lines set status_code = A count: '||sql%rowcount);
2635:
2636:
2637: -- move the transferred records to psp_pre_gen_dist_lines_history
2638: -- Introduced DFF columns for bug fix 2908859
2639: INSERT INTO psp_pre_gen_dist_lines_history
2640: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2641: element_type_id,distribution_date,effective_date,distribution_amount,

Line 2639: INSERT INTO psp_pre_gen_dist_lines_history

2635:
2636:
2637: -- move the transferred records to psp_pre_gen_dist_lines_history
2638: -- Introduced DFF columns for bug fix 2908859
2639: INSERT INTO psp_pre_gen_dist_lines_history
2640: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2641: element_type_id,distribution_date,effective_date,distribution_amount,
2642: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
2643: batch_name,status_code,set_of_books_id,

Line 2668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_pre_gen_dist_lines_history count: '||sql%rowcount);

2664: FROM psp_pre_gen_dist_lines
2665: WHERE status_code = 'A'
2666: AND summary_line_id = l_summary_line_id;
2667:
2668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_pre_gen_dist_lines_history count: '||sql%rowcount);
2669:
2670: DELETE FROM psp_pre_gen_dist_lines
2671: WHERE status_code = 'A'
2672: AND summary_line_id = l_summary_line_id;

Line 4822: -- move the transferred records to psp_pre_gen_dist_lines_history

4818: WHERE rowid = l_rowid;
4819:
4820: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Payroll type P');
4821:
4822: -- move the transferred records to psp_pre_gen_dist_lines_history
4823: INSERT INTO psp_pre_gen_dist_lines_history
4824: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4825: element_type_id,distribution_date,effective_date,distribution_amount,
4826: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4823: INSERT INTO psp_pre_gen_dist_lines_history

4819:
4820: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Payroll type P');
4821:
4822: -- move the transferred records to psp_pre_gen_dist_lines_history
4823: INSERT INTO psp_pre_gen_dist_lines_history
4824: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4825: element_type_id,distribution_date,effective_date,distribution_amount,
4826: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4827: batch_name,status_code,set_of_books_id,

Line 5388: -- move the transferred records to psp_pre_gen_dist_lines_history

5384: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5385:
5386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_pre_gen_distribution_lines for summary_line_id'||l_summary_line_id);
5387:
5388: -- move the transferred records to psp_pre_gen_dist_lines_history
5389: INSERT INTO psp_pre_gen_dist_lines_history
5390: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
5391: element_type_id,distribution_date,effective_date,distribution_amount,
5392: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 5389: INSERT INTO psp_pre_gen_dist_lines_history

5385:
5386: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Update psp_pre_gen_distribution_lines for summary_line_id'||l_summary_line_id);
5387:
5388: -- move the transferred records to psp_pre_gen_dist_lines_history
5389: INSERT INTO psp_pre_gen_dist_lines_history
5390: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
5391: element_type_id,distribution_date,effective_date,distribution_amount,
5392: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
5393: batch_name,status_code,set_of_books_id,

Line 5740: From psp_pre_gen_dist_lines_history pregen,

5736: cursor pregen_er_supercede is
5737: Select per.effort_report_id,
5738: per.person_id,
5739: min(pregen.summary_line_id)
5740: From psp_pre_gen_dist_lines_history pregen,
5741: Psp_eff_reports per,
5742: Psp_payroll_controls ppc
5743: Where pregen.distribution_date between per.start_date and per.end_date
5744: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5858: From psp_pre_gen_dist_lines_history pregen,

5854: UNION ALL
5855: Select per.effort_report_id,
5856: per.person_id,
5857: pregen.summary_line_id summary_line_id
5858: From psp_pre_gen_dist_lines_history pregen,
5859: Psp_eff_reports per,
5860: Psp_payroll_controls ppc
5861: Where pregen.distribution_date between per.start_date and per.end_date
5862: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

Line 5930: From psp_pre_gen_dist_lines_history pregen,

5926: cursor pregen_asg_er_supercede is
5927: Select per.effort_report_id,
5928: per.person_id,
5929: min(pregen.summary_line_id)
5930: From psp_pre_gen_dist_lines_history pregen,
5931: Psp_eff_reports per,
5932: Psp_payroll_controls ppc,
5933: psp_eff_report_details perd
5934: Where pregen.distribution_date between per.start_date and per.end_date

Line 6058: From psp_pre_gen_dist_lines_history pregen,

6054: UNION ALL
6055: Select per.effort_report_id,
6056: per.person_id,
6057: pregen.summary_line_id summary_line_id
6058: From psp_pre_gen_dist_lines_history pregen,
6059: Psp_eff_reports per,
6060: Psp_payroll_controls ppc,
6061: psp_eff_report_details perd
6062: Where pregen.distribution_date between per.start_date and per.end_date