DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on PER_PEOPLE_EXTRA_INFO

Line 2734: FROM per_people_extra_info

2730: -- Child Minders Sickness Quota Present
2731: BEGIN
2732: SELECT pei_information3
2733: INTO l_child_minders_quota
2734: FROM per_people_extra_info
2735: WHERE information_type = 'NO_CHILDMINDERS_QUOTA'
2736: AND person_id = p_person_id
2737: AND p_abs_start_date BETWEEN fnd_date.canonical_to_date (pei_information1)
2738: and decode(pei_information2,NULL,to_date('31/12/4712','DD/MM/YYYY'),fnd_date.canonical_to_date(pei_information2));