APPS.PSP_EFFORTS_PKG dependencies on PSP_PRE_GEN_DIST_LINES_HISTORY

Line 425: /* This cursor is based on PST_DISTRIBUTION_LINES_HISTORY ,PSP_PRE_GEN_DIST_LINES_HISTORY and

421: p_set_of_books_id IN VARCHAR2)
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)

Line 479: FROM psp_pre_gen_dist_lines_history

475: TO_NUMBER(NULL), --- N(9)
476: TO_NUMBER(NULL), --- N(9)
477: TO_NUMBER(NULL), --- N(9)
478: 'pre_gen_dist_lines'
479: FROM psp_pre_gen_dist_lines_history
480: WHERE distribution_date between sdate AND edate AND
481: person_id = person_id1 AND
482: NVL(include_in_er_flag,'Y') = 'Y' AND
483: NVL(reversal_entry_flag,'N') = 'N'

Line 573: FROM psp_pre_gen_dist_lines_history ppgh,

569: TO_NUMBER(NULL),
570: TO_NUMBER(NULL),
571: TO_NUMBER(NULL),
572: 'pre_gen_dist_lines'
573: FROM psp_pre_gen_dist_lines_history ppgh,
574: psp_summary_lines psl
575: WHERE
576: psl.person_id=person_id1 and
577: ppgh.summary_line_id=psl.summary_line_id

Line 703: FROM psp_pre_gen_dist_lines_history ppgh where

699: and nvl(INCLUDE_IN_ER_FLAG,'Y')='Y' and
700: nvl(REVERSAL_ENTRY_FLAG,'N')='N'
701: UNION ALL
702: SELECT summary_line_id
703: FROM psp_pre_gen_dist_lines_history ppgh where
704: ppgh.summary_line_id=psl.summary_line_id and
705: ppgh.distribution_date
706: BETWEEN pet.begin_date AND pet.end_date
707: and nvl(INCLUDE_IN_ER_FLAG,'Y')='Y' and

Line 747: FROM psp_pre_gen_dist_lines_history ppgh

743: and nvl(INCLUDE_IN_ER_FLAG,'Y')='Y' and
744: nvl(REVERSAL_ENTRY_FLAG,'N')='N'
745: UNION ALL
746: SELECT summary_line_id
747: FROM psp_pre_gen_dist_lines_history ppgh
748: WHERE
749: ppgh.summary_line_id=psl.summary_line_id and
750: ppgh.distribution_date
751: BETWEEN pet.begin_date AND pet.end_date

Line 1097: UPDATE psp_pre_gen_dist_lines_history

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
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