DBA Data[Home] [Help]

APPS.PAY_ORG_PAY_METH_USAGES_F_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 174: pay_personal_payment_methods_f ppm

170: p_validation_end_date date
171: ) is
172: select ppm.personal_payment_method_id
173: from per_all_assignments_f asg,
174: pay_personal_payment_methods_f ppm
175: where asg.payroll_id = p_payroll_id
176: and ppm.assignment_id = asg.assignment_id
177: and ppm.org_payment_method_id = p_org_payment_method_id
178: and ppm.effective_start_date <= asg.effective_end_date