APPS.PAY_KW_EFT dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 47: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

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

Line 181: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

177: l_inputs ff_exec.inputs_t;
178: l_outputs ff_exec.outputs_t;
179: cursor c_get_name(p_payment_method_id NUMBER) is
180: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
181: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
182: begin
183: open c_get_name(l_payment_method_id);
184: fetch c_get_name into l_id_header,l_id_body,l_id_footer,l_employer_code,l_bank_code;
185: close c_get_name;

Line 326: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

322: l_inputs ff_exec.inputs_t;
323: l_outputs ff_exec.outputs_t;
324: cursor c_get_name(p_payment_method_id NUMBER) is
325: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
326: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
327: begin
328: l_payment_method_id := p_payment_method_id;
329: open c_get_name(p_payment_method_id);
330: fetch c_get_name into l_id_header,l_id_body,l_id_footer,l_employer_code,l_bank_code;