APPS.PAY_SA_EFT SQL Statements

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

Line: 43

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

Line: 49

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F
 where ORG_PAYMENT_METHOD_ID = p_payment_method_id
 and p_Date_Earned between effective_start_date and effective_end_date ;

Line: 180

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

Line: 186

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F
 where ORG_PAYMENT_METHOD_ID = p_payment_method_id
 and p_Date_Earned between effective_start_date and effective_end_date ;

Line: 326

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

Line: 332

 select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
 from PAY_ORG_PAYMENT_METHODS_F
 where ORG_PAYMENT_METHOD_ID = p_payment_method_id
 and p_Date_Earned between effective_start_date and effective_end_date ;