APPS.PSP_SUM_ADJ dependencies on PSP_PRE_GEN_DIST_LINES_HISTORY

Line 630: psp_pre_gen_dist_lines_history pglh,

626: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
627: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
628: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
629: FROM psp_adjustment_lines pal,
630: psp_pre_gen_dist_lines_history pglh,
631: psp_summary_lines psl
632: WHERE pal.status_code = 'N'
633: AND pal.gl_code_combination_id is not null
634: AND pal.payroll_control_id = p_payroll_control_id

Line 2366: psp_pre_gen_dist_lines_history pgh,

2362: DECODE(g_dff_grouping_option, 'Y', pal.attribute8, NULL) attribute8,
2363: DECODE(g_dff_grouping_option, 'Y', pal.attribute9, NULL) attribute9,
2364: DECODE(g_dff_grouping_option, 'Y', pal.attribute10, NULL) attribute10
2365: FROM psp_adjustment_lines pal,
2366: psp_pre_gen_dist_lines_history pgh,
2367: psp_summary_lines psl
2368: WHERE pal.status_code = 'N'
2369: AND pal.gl_code_combination_id IS NULL
2370: AND pal.payroll_control_id = p_payroll_control_id

Line 4186: update psp_pre_gen_dist_lines_history

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
4187: set adjustment_batch_name = NULL
4188: where pre_gen_dist_line_id = adj_batch_rec.orig_line_id;
4189: elsif adj_batch_rec.orig_source_type = 'A' then
4190: update psp_adjustment_lines_history