APPS.PAY_CA_WORKFLOW_API_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 54

    SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
           paa.action_status ASG_STATUS
    FROM   pay_assignment_actions paa,
           pay_payroll_actions ppa
    WHERE  paa.payroll_action_id  = ppa.payroll_action_id
    AND    ppa.request_id =  to_number(p_req_id)
    AND    ppa.business_group_id = ln_business_group_id
    AND    ppa.effective_date =
                  trunc(to_date(ld_payroll_date_paid,'YYYY/MM/DD HH24:MI:SS'))
    AND    ppa.action_type = 'X'
    AND    ppa.report_type = 'ROE'
    AND    paa.source_action_id is null
    AND    paa.run_type_id is null
    GROUP BY paa.action_status;

Line: 144

    SELECT to_char(count(paa.assignment_action_id)) ASG_COUNT,
           paa.action_status ASG_STATUS
    FROM   pay_assignment_actions paa,
           pay_payroll_actions ppa
    WHERE  paa.payroll_action_id  = ppa.payroll_action_id
    AND    ppa.request_id =  to_number(p_req_id)
    AND    ppa.business_group_id = ln_business_group_id
    AND    ppa.effective_date =
                  trunc(to_date(ld_payroll_date_paid,'YYYY/MM/DD HH24:MI:SS'))
    AND    ppa.action_type = 'X'
    AND    ppa.report_type = 'MAG_ROE'
    AND    paa.source_action_id is null
    AND    paa.run_type_id is null
    GROUP BY paa.action_status;