APPS.PAY_AE_EFT SQL Statements

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

Line: 51

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

Line: 55

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

Line: 210

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

Line: 214

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

Line: 380

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

Line: 384

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