APPS.PSP_EFFORTS_PKG dependencies on PSP_DISTRIBUTION_LINES_HISTORY

Line 450: FROM psp_distribution_lines_history D,psp_payroll_sub_lines S, psp_payroll_lines L

446: D.suspense_org_account_id, --- N(9)
447: element_account_id, --- N(9)
448: org_schedule_id, --- N(9)
449: 'distribution_lines' source
450: FROM psp_distribution_lines_history D,psp_payroll_sub_lines S, psp_payroll_lines L
451: WHERE D.payroll_sub_line_id = S.payroll_sub_line_id AND
452: S.payroll_line_id = L.payroll_line_id AND
453: D.distribution_DATE between sdate AND edate AND
454: L.person_id = person_id1 AND

Line 535: FROM psp_distribution_lines_history pdlh,

531: pdlh.suspense_org_account_id,
532: element_account_id,
533: org_schedule_id,
534: 'distribution_lines' source
535: FROM psp_distribution_lines_history pdlh,
536: psp_payroll_sub_lines pps,
537: psp_payroll_lines ppl,
538: psp_summary_lines psl
539: WHERE

Line 682: FROM psp_distribution_lines_history pdlh

678: and
679: exists
680: (
681: SELECT summary_line_id
682: FROM psp_distribution_lines_history pdlh
683: WHERE
684: pdlh.summary_line_id=psl.summary_line_id and
685: pdlh.distribution_date
686: between

Line 726: FROM psp_distribution_lines_history pdlh

722: and psl.status_code||''='A'
723: and exists
724: (
725: SELECT summary_line_id
726: FROM psp_distribution_lines_history pdlh
727: WHERE
728: pdlh.summary_line_id=psl.summary_line_id and
729: pdlh.distribution_date
730: BETWEEN

Line 1093: UPDATE psp_distribution_lines_history

1089: 'R');
1090: END IF;
1091: ---
1092: IF t_DIST_row.source = 'distribution_lines' and g_template_row.report_type = 'N' THEN
1093: UPDATE psp_distribution_lines_history
1094: SET effort_report_id = NVL(t_effort_report_id,t_prev_effort_report_id)
1095: WHERE distribution_line_id = t_DIST_row.distribution_line_id;
1096: ELSIF t_DIST_row.source = 'pre_gen_dist_lines' and g_template_row.report_type = 'N' THEN
1097: UPDATE psp_pre_gen_dist_lines_history