APPS.HR_HK_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 138: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type

134: --
135: -- {End Of Comments}
136: --
137: PROCEDURE check_hk_update_legislation
138: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type
139: ,p_effective_date IN DATE
140: ) IS
141: --
142: -- Declare cursors and local variables

Line 151: pay_personal_payment_methods_f ppm

147: --
148: CURSOR legsel IS
149: SELECT pbg.legislation_code
150: FROM per_business_groups pbg,
151: pay_personal_payment_methods_f ppm
152: WHERE pbg.business_group_id = ppm.business_group_id
153: AND ppm.personal_payment_method_id = p_personal_payment_method_id
154: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
155: --