APPS.HR_SG_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 158: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type

154: --
155: -- {End Of Comments}
156: --
157: PROCEDURE check_sg_update_legislation
158: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type
159: ,p_effective_date IN DATE
160: ) IS
161: --
162: -- Declare cursors and local variables

Line 171: pay_personal_payment_methods_f ppm

167: --
168: CURSOR legsel IS
169: SELECT pbg.legislation_code
170: FROM per_business_groups pbg,
171: pay_personal_payment_methods_f ppm
172: WHERE pbg.business_group_id = ppm.business_group_id
173: AND ppm.personal_payment_method_id = p_personal_payment_method_id
174: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
175: --