DBA Data[Home] [Help]

APPS.PAY_US_PPM_HOOK dependencies on PAY_ORG_PAYMENT_METHODS

Line 66: from pay_org_payment_methods_f where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID

62: begin
63:
64: select PMETH_INFORMATION9
65: INTO l_is_foreign_trans
66: from pay_org_payment_methods_f where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
67: AND p_effective_date BETWEEN effective_start_date
68: AND effective_end_date;
69:
70: hr_utility.trace('l_is_foreign_trans : ' || l_is_foreign_trans);

Line 146: from pay_org_payment_methods popm, pay_Personal_payment_methods pppm

142: begin
143:
144: select popm.PMETH_INFORMATION9
145: INTO l_is_foreign_trans
146: from pay_org_payment_methods popm, pay_Personal_payment_methods pppm
147: where popm.ORG_PAYMENT_METHOD_ID = pppm.ORG_PAYMENT_METHOD_ID
148: and pppm.PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
149: AND p_effective_date BETWEEN popm.effective_start_date
150: AND popm.effective_end_date;