APPS.PER_NAA_BUS dependencies on PER_ABSENCE_ATTENDANCES

Line 53: from per_absence_attendances paa

49: -- Declare cursor
50: --
51: cursor cur_chk_abs_atte_id is
52: select 1
53: from per_absence_attendances paa
54: where absence_attendance_id = p_absence_attendance_id;
55: --
56: -- local variables
57: l_proc varchar2(72) := g_package||'chk_absence_attendance_id';

Line 121: per_absence_attendances paa,

117: --
118: cursor cur_chk_abs_cat_user_tables is
119: select 1
120: from pay_user_tables put,
121: per_absence_attendances paa,
122: per_absence_attendance_types paat
123: where put.user_table_name = 'NL_ABS_ACTION_'||paat.absence_category
124: and paa.absence_attendance_type_id = paat.absence_attendance_type_id
125: and paa.absence_attendance_id = p_absence_attendance_id

Line 192: from per_absence_attendances paa

188: -- Declare cursor
189: --
190: cursor cur_chk_expected_date is -- Changes as per bug 2637189
191: select nvl(date_start,date_projected_start) absence_date
192: from per_absence_attendances paa
193: where absence_attendance_id = p_absence_attendance_id;
194: --
195: -- local variables
196: l_proc varchar2(72) := g_package||'chk_expected_date';

Line 421: , per_absence_attendances paa

417: cursor csr_sec_grp is
418: select pbg.security_group_id
419: from per_business_groups pbg
420: , per_nl_absence_actions naa
421: , per_absence_attendances paa
422: where naa.absence_action_id = p_absence_action_id
423: and naa.absence_attendance_id = paa.absence_attendance_id
424: and pbg.business_group_id = paa.business_group_id;
425: --

Line 482: , per_absence_attendances paa

478: cursor csr_leg_code is
479: select pbg.legislation_code
480: from per_business_groups pbg
481: , per_nl_absence_actions naa
482: , per_absence_attendances paa
483: where naa.absence_action_id = p_absence_action_id
484: and paa.absence_attendance_id = naa.absence_attendance_id
485: and pbg.business_group_id = paa.business_group_id;
486: --