DBA Data[Home] [Help]

APPS.PAY_NL_IZA_UPLOAD dependencies on PER_ABSENCE_ATTENDANCES

Line 1389: from PER_ABSENCE_ATTENDANCES paa

1385:
1386:
1387: cursor csr_abs_days(v_person_id number,v_bg_id number,v_period_start_date date,v_period_end_date date) IS
1388: select sum((NVL(paa.date_end,paa.date_start) - paa.date_start)+1)
1389: from PER_ABSENCE_ATTENDANCES paa
1390: where paa.business_group_id = v_bg_id
1391: and paa.person_id = v_person_id
1392: and decode(paa.ABS_INFORMATION_CATEGORY,'NL_S',ABS_INFORMATION2,ABS_INFORMATION1) = 'Y'
1393: and v_period_end_date >= paa.date_start