3391: and prv.PRTT_RT_VAL_STAT_CD is NULL
3392: and prv.ELEMENT_ENTRY_VALUE_ID is not NULL;
3393:
3394: cursor c_chk_payroll_run is 3395: select 'y' from dual where exists 3396: (SELECT NULL
3397: FROM pay_payroll_actions pac,
3398: pay_assignment_actions act,
3399: per_assignments_f asg