APPS.PSP_SUM_ADJ dependencies on PSP_PRE_GEN_DIST_LINES_HISTORY

Line 706: psp_pre_gen_dist_lines_history pglh,

702: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
703: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
704: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
705: FROM psp_adjustment_lines pal,
706: psp_pre_gen_dist_lines_history pglh,
707: psp_summary_lines psl
708: WHERE pal.status_code = 'N'
709: AND pal.gl_code_combination_id is not null
710: AND pal.payroll_control_id = p_payroll_control_id

Line 2490: psp_pre_gen_dist_lines_history pgh,

2486: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2487: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2488: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2489: FROM psp_adjustment_lines pal,
2490: psp_pre_gen_dist_lines_history pgh,
2491: psp_summary_lines psl
2492: WHERE pal.status_code = 'N'
2493: AND pal.gl_code_combination_id IS NULL
2494: AND pal.payroll_control_id = p_payroll_control_id

Line 4617: update psp_pre_gen_dist_lines_history

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
4618: set adjustment_batch_name = NULL
4619: where pre_gen_dist_line_id = adj_batch_rec.orig_line_id;
4620: elsif adj_batch_rec.orig_source_type = 'A' then
4621: update psp_adjustment_lines_history