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 3268: UPDATE psp_distribution_lines_history

3264:
3265: hr_utility.trace('Inserted into PSP_ADJUSTMENT_LINES - 10');
3266:
3267: /***** Converted the following update statements into BULK update for R12 performance fixes (bug 4507892)
3268: UPDATE psp_distribution_lines_history
3269: SET adjustment_batch_name = p_batch_name
3270: WHERE distribution_line_id in ( select orig_line_id
3271: from psp_adjustment_lines
3272: where payroll_control_id = l_payroll_control_id

Line 3302: UPDATE psp_distribution_lines_history

3298:
3299: hr_utility.trace('r_orig_lines.orig_line_id.COUNT = '||r_orig_lines.orig_line_id.COUNT);
3300:
3301: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3302: UPDATE psp_distribution_lines_history
3303: SET adjustment_batch_name = p_batch_name
3304: WHERE distribution_line_id = r_orig_lines.orig_line_id(I)
3305: AND r_orig_lines.orig_source_type(I) = 'D';
3306:

Line 4314: /* PSP_PRE_GEN_DIST_LINES_HISTORY or PSP_DISTRIBUTION_LINES_HISTORY */

4310: SAVEPOINT undo_adj_savepoint;
4311:
4312: /*---------------------------------------------------------------------*/
4313: /*1. Update one of the history tables PSP_ADJUSTMENT_LINES_HISTORY or */
4314: /* PSP_PRE_GEN_DIST_LINES_HISTORY or PSP_DISTRIBUTION_LINES_HISTORY */
4315: /* by setting the adjustment_batch_name to NULL. */
4316: /*---------------------------------------------------------------------*/
4317: OPEN get_line_id_csr;
4318: LOOP

Line 4330: UPDATE psp_distribution_lines_history

4326: UPDATE psp_pre_gen_dist_lines_history
4327: SET adjustment_batch_name = NULL
4328: WHERE pre_gen_dist_line_id = l_orig_line_id;
4329: ELSIF (l_orig_source_type = 'D') THEN
4330: UPDATE psp_distribution_lines_history
4331: SET adjustment_batch_name = NULL
4332: WHERE distribution_line_id = l_orig_line_id;
4333: END IF;
4334: END LOOP;