APPS.PAY_PROGRESS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 32: FROM pay_assignment_actions

28: SELECT NVL(SUM(DECODE(action_status,'C',1,'S',1,0)),0) completed,
29: NVL(SUM(DECODE(action_status,'E',1,0)),0) in_error,
30: NVL(SUM(DECODE(action_status,'M',1,0)),0) marked_for_retry,
31: NVL(SUM(DECODE(action_status,'U',1,0)),0) unprocessed
32: FROM pay_assignment_actions
33: WHERE payroll_action_id = cp_id
34: AND source_action_id IS NULL;
35: --
36: -- Determine various statistics used for calculating timing information