APPS.PSP_ENC_PRE_PROCESS dependencies on PSP_ENC_CONTROLS

Line 1475: /*CURSOR for selecting maximum creation date from psp_enc_controls for which lines are not liquidated*/

1471: IS
1472:
1473: l_enc_cr_date DATE;
1474:
1475: /*CURSOR for selecting maximum creation date from psp_enc_controls for which lines are not liquidated*/
1476: CURSOR max_create_dt_cur IS
1477: SELECT max(pec.creation_date)
1478: FROM PSP_ENC_CONTROLS pec
1479: WHERE pec.payroll_id = p_payroll_id

Line 1478: FROM PSP_ENC_CONTROLS pec

1474:
1475: /*CURSOR for selecting maximum creation date from psp_enc_controls for which lines are not liquidated*/
1476: CURSOR max_create_dt_cur IS
1477: SELECT max(pec.creation_date)
1478: FROM PSP_ENC_CONTROLS pec
1479: WHERE pec.payroll_id = p_payroll_id
1480: AND pec.action_code IN ('I', 'N', 'P'); -- Replaced <> 'L' with IN clause for bug fix 3099540
1481:
1482: /* CURSOR to verify modification in pa_trancation_controls after the last creation date */