APPS.PSP_SUM_ADJ dependencies on PSP_DISTRIBUTION_LINES_HISTORY

Line 568: psp_distribution_lines_history pdlh,

564: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
565: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
566: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
567: FROM psp_adjustment_lines pal,
568: psp_distribution_lines_history pdlh,
569: psp_summary_lines psl
570: WHERE pal.status_code = 'N'
571: AND pal.gl_code_combination_id is not null
572: AND pal.payroll_control_id = p_payroll_control_id

Line 2296: psp_distribution_lines_history pdh,

2292: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2293: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2294: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2295: FROM psp_adjustment_lines pal,
2296: psp_distribution_lines_history pdh,
2297: psp_summary_lines psl
2298: WHERE pal.status_code = 'N'
2299: AND pal.gl_code_combination_id IS NULL
2300: AND pal.payroll_control_id = p_payroll_control_id

Line 4182: update psp_distribution_lines_history

4178: close adj_batch_cur;
4179: exit;
4180: end if;
4181: if (adj_batch_rec.orig_source_type = 'D') then
4182: update psp_distribution_lines_history
4183: set adjustment_batch_name = NULL
4184: where distribution_line_id = adj_batch_rec.orig_line_id;
4185: elsif adj_batch_rec.orig_source_type = 'P' then
4186: update psp_pre_gen_dist_lines_history