APPS.PER_NAA_BUS dependencies on PER_NL_ABSENCE_ACTIONS

Line 370: from per_nl_absence_actions paa

366: -- Declare cursor
367: --
368: cursor cur_chk_abs_act_id is
369: select object_version_number
370: from per_nl_absence_actions paa
371: where absence_action_id = p_absence_action_id;
372: --
373: -- local variables
374: l_proc varchar2(72) := g_package||'chk_absence_action_id';

Line 420: , per_nl_absence_actions naa

416: --
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;

Line 481: , per_nl_absence_actions naa

477: --
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;