DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_ENC_CHANGED_SCHEDULES

Line 1666: FROM psp_enc_changed_schedules pecs;

1662: SELECT DISTINCT reference_id,
1663: pecs.reference_field,
1664: pecs.change_type,
1665: DECODE(action_type, 'D', 'U', action_type) action_type
1666: FROM psp_enc_changed_schedules pecs;
1667:
1668: /* Following cursor finds out NOCOPY assignments affected by changes to Org Default LS */
1669: CURSOR assignment_payroll_ds_upd_cur(p_reference_id NUMBER) IS
1670: SELECT DISTINCT pelh.assignment_id,

Line 2162: DELETE psp_enc_changed_schedules;

2158: r_reference_id_array.r_change_type.DELETE;
2159: r_reference_id_array.r_reference_field.DELETE;
2160: r_reference_id_array.r_action_type.DELETE;
2161:
2162: DELETE psp_enc_changed_schedules;
2163:
2164: l_proc_step := 190; -- Introduced for bug fix 3434626
2165:
2166: COMMIT;