DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 153: FROM per_absence_attendance_types

149: CURSOR csr_generate_max_days (csr_v_absence_type_id NUMBER)
150: IS
151: SELECT information2 generate
152: ,information3 max_days
153: FROM per_absence_attendance_types
154: WHERE absence_attendance_type_id = csr_v_absence_type_id;
155:
156: CURSOR csr_earning_year
157: IS

Line 580: FROM PER_ABSENCE_ATTENDANCE_TYPES

576: CURSOR csr_generate_max_days
577: IS
578: /*SELECT INFORMATION2 Generate
579: ,INFORMATION3 Max_Days
580: FROM PER_ABSENCE_ATTENDANCE_TYPES
581: WHERE ABSENCE_ATTENDANCE_TYPE_ID=csr_v_absence_type_id;*/
582: SELECT hoi4.org_information2
583: ,hoi4.org_information3
584: FROM hr_organization_units o1