DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 2859: from pay_org_payment_methods_f o

2855: hr_utility.set_location(l_proc, 170);
2856: --
2857: select greatest(max(o.effective_start_date),l_new_start_date)
2858: into l_ppm_start_date
2859: from pay_org_payment_methods_f o
2860: where o.org_payment_method_id = ( select org_payment_method_id from(
2861: select p.org_payment_method_id
2862: from pay_personal_payment_methods_f p
2863: where p.effective_start_date >= l_old_start_date