APPS.PSP_EFFORTS_PKG dependencies on PSP_ADJUSTMENT_LINES_HISTORY

Line 426: PSP_ADJUSTMENT_LINES_HISTORY */

422: IS
423:
424: CURSOR t_DIST (person_id1 NUMBER, sdate DATE, edate DATE) IS
425: /* This cursor is based on PST_DISTRIBUTION_LINES_HISTORY ,PSP_PRE_GEN_DIST_LINES_HISTORY and
426: PSP_ADJUSTMENT_LINES_HISTORY */
427: /*commented out and replaced by new cursor for perf. fix bug 1874615 -- ddubey 12-JUl-2001.
428: SELECT D.distribution_line_id, --- N(10)
429: L.person_id person_id, --- N(9)
430: L.assignment_id assignment_id, --- N(9)

Line 506: FROM psp_adjustment_lines_history

502: TO_NUMBER(NULL), --- N(9)
503: TO_NUMBER(NULL), --- N(9)
504: TO_NUMBER(NULL), --- N(9)
505: 'adjustment_lines'
506: FROM psp_adjustment_lines_history
507: WHERE distribution_date between sdate AND edate AND
508: person_id = person_id1 AND
509: NVL(include_in_er_flag,'Y') = 'Y' AND
510: NVL(reversal_entry_flag,'N') = 'N'

Line 606: FROM psp_adjustment_lines_history palh,

602: TO_NUMBER(NULL),
603: TO_NUMBER(NULL),
604: TO_NUMBER(NULL),
605: 'adjustment_lines'
606: FROM psp_adjustment_lines_history palh,
607: psp_summary_lines psl
608: WHERE
609: psl.person_id=person_id1 and
610: palh.summary_line_id=psl.summary_line_id and

Line 694: FROM psp_adjustment_lineS_history palh

690: and nvl(INCLUDE_IN_ER_FLAG,'Y')='Y' and
691: nvl(REVERSAL_ENTRY_FLAG,'N')='N'
692: UNION ALL
693: SELECT summary_line_id
694: FROM psp_adjustment_lineS_history palh
695: WHERE
696: palh.summary_line_id=psl.summary_line_id and
697: palh.distribution_date
698: BETWEEN pet.begin_date AND pet.end_date

Line 738: FROM psp_adjustment_lines_history palh

734: and nvl(INCLUDE_IN_ER_FLAG,'Y')='Y' and
735: nvl(REVERSAL_ENTRY_FLAG,'N')='N'
736: UNION ALL
737: SELECT summary_line_id
738: FROM psp_adjustment_lines_history palh
739: WHERE
740: palh.summary_line_id=psl.summary_line_id and
741: palh.distribution_date
742: BETWEEN pet.begin_date and pet.end_date

Line 1101: UPDATE psp_adjustment_lines_history

1097: UPDATE psp_pre_gen_dist_lines_history
1098: SET effort_report_id = NVL(t_effort_report_id,t_prev_effort_report_id)
1099: WHERE pre_gen_dist_line_id = t_DIST_row.distribution_line_id;
1100: ELSIF t_DIST_row.source = 'adjustment_lines' and g_template_row.report_type = 'N' THEN
1101: UPDATE psp_adjustment_lines_history
1102: SET effort_report_id = NVL(t_effort_report_id,t_prev_effort_report_id)
1103: WHERE adjustment_line_id = t_DIST_row.distribution_line_id;
1104: END IF;
1105: ---