APPS.PAY_SA_EFT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 44: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

40: l_inputs ff_exec.inputs_t;
41: l_outputs ff_exec.outputs_t;
42: cursor c_get_name(p_payment_method_id NUMBER) is
43: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
44: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
45: begin
46: --hr_utility.trace_on(null,'EFT');
47: l_payment_method_id := p_payment_method_id;
48: open c_get_name(p_payment_method_id);

Line 171: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

167: l_inputs ff_exec.inputs_t;
168: l_outputs ff_exec.outputs_t;
169: cursor c_get_name(p_payment_method_id NUMBER) is
170: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
171: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
172: begin
173: l_inputs(1).name := 'ASSIGNMENT_ID';
174: l_inputs(1).value := p_assignment_id;
175: l_inputs(2).name := 'BUSINESS_GROUP_ID';

Line 307: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

303: l_inputs ff_exec.inputs_t;
304: l_outputs ff_exec.outputs_t;
305: cursor c_get_name(p_payment_method_id NUMBER) is
306: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
307: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
308: begin
309: open c_get_name(p_payment_method_id);
310: fetch c_get_name into l_id_header,l_id_body,l_id_footer;
311: close c_get_name;