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: begin
55: --hr_utility.trace_on(null,'EFT');
56: l_payment_method_id := p_payment_method_id;

Line 205: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

201: l_outputs ff_exec.outputs_t;
202:
203: cursor c_get_name(p_payment_method_id NUMBER) is
204: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
205: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
206:
207: begin
208:
209: open c_get_name(l_payment_method_id);

Line 369: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

365: l_outputs ff_exec.outputs_t;
366:
367: cursor c_get_name(p_payment_method_id NUMBER) is
368: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
369: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
370:
371: begin
372: l_payment_method_id := p_payment_method_id;
373: