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 181: psp_pre_gen_dist_lines_history ppg,

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

Line 3266: UPDATE psp_pre_gen_dist_lines_history

3262: from psp_adjustment_lines
3263: where payroll_control_id = l_payroll_control_id
3264: and orig_source_type = 'D');
3265:
3266: UPDATE psp_pre_gen_dist_lines_history
3267: SET adjustment_batch_name = p_batch_name
3268: WHERE pre_gen_dist_line_id in ( select orig_line_id
3269: from psp_adjustment_lines
3270: where payroll_control_id = l_payroll_control_id

Line 3299: UPDATE psp_pre_gen_dist_lines_history

3295: WHERE distribution_line_id = r_orig_lines.orig_line_id(I)
3296: AND r_orig_lines.orig_source_type(I) = 'D';
3297:
3298: FORALL I IN 1..r_orig_lines.orig_line_id.COUNT
3299: UPDATE psp_pre_gen_dist_lines_history
3300: SET adjustment_batch_name = p_batch_name
3301: WHERE pre_gen_dist_line_id = r_orig_lines.orig_line_id(I)
3302: AND r_orig_lines.orig_source_type(I) = 'P';
3303:

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

4313: UPDATE psp_adjustment_lines_history
4314: SET adjustment_batch_name = NULL
4315: WHERE adjustment_line_id = l_orig_line_id;
4316: ELSIF (l_orig_source_type = 'P') THEN
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