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:
46: /* Added for Bug 10085376 */
47:
48: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is

Line 50: from PAY_ORG_PAYMENT_METHODS_F

46: /* Added for Bug 10085376 */
47:
48: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
49: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
50: from PAY_ORG_PAYMENT_METHODS_F
51: where ORG_PAYMENT_METHOD_ID = p_payment_method_id
52: and p_Date_Earned between effective_start_date and effective_end_date ;
53:
54: begin

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

177: l_outputs ff_exec.outputs_t;
178:
179: /*cursor c_get_name(p_payment_method_id NUMBER) is
180: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
181: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
182:
183: /* Added for Bug 10085376 */
184:
185: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is

Line 187: from PAY_ORG_PAYMENT_METHODS_F

183: /* Added for Bug 10085376 */
184:
185: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
186: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
187: from PAY_ORG_PAYMENT_METHODS_F
188: where ORG_PAYMENT_METHOD_ID = p_payment_method_id
189: and p_Date_Earned between effective_start_date and effective_end_date ;
190:
191: begin

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

323: l_outputs ff_exec.outputs_t;
324:
325: /*cursor c_get_name(p_payment_method_id NUMBER) is
326: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
327: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */
328:
329: /* Added for Bug 10085376 */
330:
331: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is

Line 333: from PAY_ORG_PAYMENT_METHODS_F

329: /* Added for Bug 10085376 */
330:
331: cursor c_get_name(p_payment_method_id NUMBER,p_Date_Earned DATE) is
332: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
333: from PAY_ORG_PAYMENT_METHODS_F
334: where ORG_PAYMENT_METHOD_ID = p_payment_method_id
335: and p_Date_Earned between effective_start_date and effective_end_date ;
336:
337: begin