DBA Data[Home] [Help]

APPS.HR_NZ_PERSONAL_PAY_METHOD_API dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 84: (p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%TYPE

80: END check_insert_legislation;
81:
82:
83: PROCEDURE check_update_legislation
84: (p_personal_payment_method_id IN pay_personal_payment_methods_f.personal_payment_method_id%TYPE
85: ,p_effective_date IN DATE
86: ,p_leg_code IN VARCHAR2
87: ) is
88: --

Line 97: pay_personal_payment_methods_f ppm

93: --
94: CURSOR csr_legcode is
95: SELECT pbg.legislation_code
96: FROM per_business_groups pbg,
97: pay_personal_payment_methods_f ppm
98: WHERE pbg.business_group_id = ppm.business_group_id
99: AND ppm.personal_payment_method_id = p_personal_payment_method_id
100: AND p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
101: --