DBA Data[Home] [Help]

APPS.PAY_HK_EXC dependencies on PAY_HK_AVG_PAY

Line 675: l_start_date := pay_hk_avg_pay.specified_date_absence(l_date_earned,l_assignment_id);

671: FETCH get_date_earned INTO l_date_earned,l_assignment_id;
672: CLOSE get_date_earned;
673:
674: /* To fetch the start_date from absence element*/
675: l_start_date := pay_hk_avg_pay.specified_date_absence(l_date_earned,l_assignment_id);
676: IF l_start_date IS NULL
677: THEN
678: /* If absence is not present then fetch the start_date from Specified Date element*/
679: l_start_date := pay_hk_avg_pay.specified_date_element(l_date_earned,l_assignment_id);

Line 679: l_start_date := pay_hk_avg_pay.specified_date_element(l_date_earned,l_assignment_id);

675: l_start_date := pay_hk_avg_pay.specified_date_absence(l_date_earned,l_assignment_id);
676: IF l_start_date IS NULL
677: THEN
678: /* If absence is not present then fetch the start_date from Specified Date element*/
679: l_start_date := pay_hk_avg_pay.specified_date_element(l_date_earned,l_assignment_id);
680: IF l_start_date IS NULL
681: THEN
682: /* If absence is not present then consider start_date as the effectice_date */
683: l_start_date := l_date_earned;