DBA Data[Home] [Help]

APPS.PAY_AE_EFT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 52: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

48: l_outputs ff_exec.outputs_t;
49:
50: /*cursor c_get_name(p_payment_method_id NUMBER) is
51: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
52: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
53:
54: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
55: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
56: from PAY_ORG_PAYMENT_METHODS_F pom

Line 56: from PAY_ORG_PAYMENT_METHODS_F pom

52: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
53:
54: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
55: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
56: from PAY_ORG_PAYMENT_METHODS_F pom
57: where pom.ORG_PAYMENT_METHOD_ID = p_payment_method_id
58: and p_Date_Earned between pom.effective_start_date and pom.effective_end_date ;
59:
60: begin

Line 211: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

207: l_outputs ff_exec.outputs_t;
208:
209: /*cursor c_get_name(p_payment_method_id NUMBER) is
210: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
211: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
212:
213: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
214: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
215: from PAY_ORG_PAYMENT_METHODS_F pom

Line 215: from PAY_ORG_PAYMENT_METHODS_F pom

211: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
212:
213: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
214: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
215: from PAY_ORG_PAYMENT_METHODS_F pom
216: where pom.ORG_PAYMENT_METHOD_ID = p_payment_method_id
217: and p_Date_Earned between pom.effective_start_date and pom.effective_end_date ;
218:
219: begin

Line 381: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;*/

377: l_outputs ff_exec.outputs_t;
378:
379: /*cursor c_get_name(p_payment_method_id NUMBER) is
380: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
381: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;*/
382:
383: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
384: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
385: from PAY_ORG_PAYMENT_METHODS_F pom

Line 385: from PAY_ORG_PAYMENT_METHODS_F pom

381: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;*/
382:
383: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
384: select pom.PMETH_INFORMATION1,pom.PMETH_INFORMATION2,pom.PMETH_INFORMATION3,pom.PMETH_INFORMATION4,pom.PMETH_INFORMATION5
385: from PAY_ORG_PAYMENT_METHODS_F pom
386: where pom.ORG_PAYMENT_METHOD_ID = p_payment_method_id
387: and p_Date_Earned between pom.effective_start_date and pom.effective_end_date ;
388:
389: begin