APPS.PSP_SUM_ADJ dependencies on PSP_DISTRIBUTION_LINES_HISTORY

Line 644: psp_distribution_lines_history pdlh,

640: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
641: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
642: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
643: FROM psp_adjustment_lines pal,
644: psp_distribution_lines_history pdlh,
645: psp_summary_lines psl
646: WHERE pal.status_code = 'N'
647: AND pal.gl_code_combination_id is not null
648: AND pal.payroll_control_id = p_payroll_control_id

Line 2420: psp_distribution_lines_history pdh,

2416: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2417: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2418: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2419: FROM psp_adjustment_lines pal,
2420: psp_distribution_lines_history pdh,
2421: psp_summary_lines psl
2422: WHERE pal.status_code = 'N'
2423: AND pal.gl_code_combination_id IS NULL
2424: AND pal.payroll_control_id = p_payroll_control_id

Line 4613: update psp_distribution_lines_history

4609: close adj_batch_cur;
4610: exit;
4611: end if;
4612: if (adj_batch_rec.orig_source_type = 'D') then
4613: update psp_distribution_lines_history
4614: set adjustment_batch_name = NULL
4615: where distribution_line_id = adj_batch_rec.orig_line_id;
4616: elsif adj_batch_rec.orig_source_type = 'P' then
4617: update psp_pre_gen_dist_lines_history