APPS.PAY_KW_TRAN_IDENTIFIERS SQL Statements

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

Line: 50

            select overriding_dd_date
            from pay_payroll_actions
            where payroll_action_id = p_payroll_action_id;

Line: 56

           select PMETH_INFORMATION6
            from PAY_ORG_PAYMENT_METHODS_F
	    where ORG_PAYMENT_METHOD_ID = p_org_payment_method_id;

Line: 77

          EXECUTE IMMEDIATE 'select '||l_func_name||'(:1,:2,:3,:4,:5,:6,:7,:8,:9) from dual'
          INTO l_return_value
          USING p_effective_date ,
                p_identifier_name,
                p_payroll_action_id,
                p_payment_type_id,
                p_org_payment_method_id,
                p_personal_payment_method_id,
                p_assignment_action_id,
                p_pre_payment_id,
                p_delimiter_string ;