DBA Data[Home] [Help]

APPS.HR_MX_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 201: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;

197: -- Declare cursors and local variables
198: --
199: l_proc VARCHAR2(72);
200: l_effective_date DATE;
201: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
202:
203: CURSOR csr_get_bg IS
204: SELECT business_group_id
205: FROM pay_personal_payment_methods_f

Line 205: FROM pay_personal_payment_methods_f

201: l_business_group_id pay_personal_payment_methods_f.business_group_id%TYPE;
202:
203: CURSOR csr_get_bg IS
204: SELECT business_group_id
205: FROM pay_personal_payment_methods_f
206: WHERE personal_payment_method_id = p_personal_payment_method_id
207: AND rownum < 2;
208: --
209: BEGIN