DBA Data[Home] [Help]

APPS.HR_AU_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 162: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type

158: --
159: -- {End Of Comments}
160: --
161: PROCEDURE check_au_update_legislation
162: ( p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%type
163: ,p_effective_date IN DATE
164: ) IS
165: --
166: -- Declare cursors and local variables

Line 175: pay_personal_payment_methods_f ppm

171: --
172: CURSOR legsel IS
173: SELECT pbg.legislation_code
174: FROM per_business_groups pbg,
175: pay_personal_payment_methods_f ppm
176: WHERE pbg.business_group_id = ppm.business_group_id
177: AND ppm.personal_payment_method_id = p_personal_payment_method_id
178: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
179: --