APPS.PSP_ADJ_DRIVER dependencies on PSP_DISTRIBUTION_LINES_HISTORY

Line 52: For the table psp_distribution_lines_history, if

48: p_set_of_books_id IN Number) IS
49:
50: /* This cursor selects from three different tables.
51:
52: For the table psp_distribution_lines_history, if
53: suspense account information is present, then a join
54: to the suspense table is used to get the GL or POETA
55: account information. Otherwise, the information
56: is found from element account, schedule line,

Line 99: psp_distribution_lines_history pdl,

95: DECODE(g_dff_grouping_option, 'Y', psl.attribute8, NULL) attribute8,
96: DECODE(g_dff_grouping_option, 'Y', psl.attribute9, NULL) attribute9,
97: DECODE(g_dff_grouping_option, 'Y', psl.attribute10, NULL) attribute10
98: FROM
99: psp_distribution_lines_history pdl,
100: psp_payroll_lines ppl,
101: psp_payroll_sub_lines ppsl,
102: psp_summary_lines psl,
103: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug 3658235

Line 3259: UPDATE psp_distribution_lines_history

3255:
3256: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 10');
3257:
3258: /***** Converted the following update statements into BULK update for R12 performance fixes (bug 4507892)
3259: UPDATE psp_distribution_lines_history
3260: SET adjustment_batch_name = p_batch_name
3261: WHERE distribution_line_id in ( select orig_line_id
3262: from psp_adjustment_lines
3263: where payroll_control_id = l_payroll_control_id

Line 3293: UPDATE psp_distribution_lines_history

3289:
3290: hr_utility.trace('r_orig_lines.orig_line_id.COUNT = '||r_orig_lines.orig_line_id.COUNT);
3291:
3292: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3293: UPDATE psp_distribution_lines_history
3294: SET adjustment_batch_name = p_batch_name
3295: WHERE distribution_line_id = r_orig_lines.orig_line_id(I)
3296: AND r_orig_lines.orig_source_type(I) = 'D';
3297:

Line 4305: /* PSP_PRE_GEN_DIST_LINES_HISTORY or PSP_DISTRIBUTION_LINES_HISTORY */

4301: SAVEPOINT undo_adj_savepoint;
4302:
4303: /*---------------------------------------------------------------------*/
4304: /*1. Update one of the history tables PSP_ADJUSTMENT_LINES_HISTORY or */
4305: /* PSP_PRE_GEN_DIST_LINES_HISTORY or PSP_DISTRIBUTION_LINES_HISTORY */
4306: /* by setting the adjustment_batch_name to NULL. */
4307: /*---------------------------------------------------------------------*/
4308: OPEN get_line_id_csr;
4309: LOOP

Line 4321: UPDATE psp_distribution_lines_history

4317: UPDATE psp_pre_gen_dist_lines_history
4318: SET adjustment_batch_name = NULL
4319: WHERE pre_gen_dist_line_id = l_orig_line_id;
4320: ELSIF (l_orig_source_type = 'D') THEN
4321: UPDATE psp_distribution_lines_history
4322: SET adjustment_batch_name = NULL
4323: WHERE distribution_line_id = l_orig_line_id;
4324: END IF;
4325: END LOOP;