APPS.PSP_ADJ_DRIVER dependencies on PSP_PRE_GEN_DIST_LINES_HISTORY

Line 27: -- 2. PSP_PRE_GEN_DIST_LINES_HISTORY (pre generated lines that have

23: -- distribution lines from the following 3 tables that match
24: -- the query find selection criteria.
25: --
26: -- 1. PSP_DISTRIUTION_LINES_HISTORY (lines taht have not been adjusted)
27: -- 2. PSP_PRE_GEN_DIST_LINES_HISTORY (pre generated lines that have
28: -- not been adjusted)
29: -- 3. PSP_ADJUSTMENT_LINES_HISTORY (lines that have been adjusted)
30: --
31: -- For each line found, a call is made to the procedure

Line 59: For the tables psp_pre_gen_dist_lines_history

55: account information. Otherwise, the information
56: is found from element account, schedule line,
57: default labor schedule, or default org account tables.
58:
59: For the tables psp_pre_gen_dist_lines_history
60: and psp_adjustment_lines_history, account information
61: is taken from suspense account if present, otherwise
62: it is taken from the line. */
63:

Line 183: psp_pre_gen_dist_lines_history ppg,

179: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute8, pos.attribute8), NULL) attribute8,
180: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
181: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
182: FROM
183: psp_pre_gen_dist_lines_history ppg,
184: psp_organization_accounts pos ,
185: --psp_group_element_list pgel, --- added for DA-ENH Modified to inline query for bug fix 3658235
186: (SELECT max(peg.element_group_id) element_group_id, pgel.element_type_id --Bug 14128743
187: FROM psp_element_groups peg, psp_group_element_list pgel

Line 3275: UPDATE psp_pre_gen_dist_lines_history

3271: from psp_adjustment_lines
3272: where payroll_control_id = l_payroll_control_id
3273: and orig_source_type = 'D');
3274:
3275: UPDATE psp_pre_gen_dist_lines_history
3276: SET adjustment_batch_name = p_batch_name
3277: WHERE pre_gen_dist_line_id in ( select orig_line_id
3278: from psp_adjustment_lines
3279: where payroll_control_id = l_payroll_control_id

Line 3308: UPDATE psp_pre_gen_dist_lines_history

3304: WHERE distribution_line_id = r_orig_lines.orig_line_id(I)
3305: AND r_orig_lines.orig_source_type(I) = 'D';
3306:
3307: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3308: UPDATE psp_pre_gen_dist_lines_history
3309: SET adjustment_batch_name = p_batch_name
3310: WHERE pre_gen_dist_line_id = r_orig_lines.orig_line_id(I)
3311: AND r_orig_lines.orig_source_type(I) = 'P';
3312:

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 4326: UPDATE psp_pre_gen_dist_lines_history

4322: UPDATE psp_adjustment_lines_history
4323: SET adjustment_batch_name = NULL
4324: WHERE adjustment_line_id = l_orig_line_id;
4325: ELSIF (l_orig_source_type = 'P') THEN
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