APPS.PAY_PROGRESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS
Line 43: FROM pay_assignment_actions
39: SELECT NVL(SUM(DECODE(action_status,'C',1,'S',1,0)),0) completed,
40: NVL(SUM(DECODE(action_status,'E',1,0)),0) in_error,
41: NVL(SUM(DECODE(action_status,'M',1,0)),0) marked_for_retry,
42: NVL(SUM(DECODE(action_status,'U',1,0)),0) unprocessed 43: FROM pay_assignment_actions 44: WHERE payroll_action_id = cp_id
45: AND source_action_id IS NULL;
46: --
47: -- Determine various statistics used for calculating timing information