APPS.PER_ABC_BUS dependencies on PER_ABSENCE_CASES

Line 31: , per_absence_cases abc

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_absence_cases abc
32: where abc.absence_case_id = p_absence_case_id
33: and pbg.business_group_id = abc.business_group_id;
34: --
35: -- Declare local variables

Line 101: , per_absence_cases pbc

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_absence_cases pbc
102: where pbc.absence_case_id = p_absence_case_id
103: and pbg.business_group_id = pbc.business_group_id;
104: --
105: -- Declare local variables

Line 447: ,p_descflex_name => 'PER_ABSENCE_CASES'

443: -- b) During insert.
444: --
445: hr_dflex_utility.ins_or_upd_descflex_attribs
446: (p_appl_short_name => 'PER'
447: ,p_descflex_name => 'PER_ABSENCE_CASES'
448: ,p_attribute_category => p_rec.ac_attribute_category
449: ,p_attribute1_name => 'ATTRIBUTE1'
450: ,p_attribute1_value => p_rec.attribute1
451: ,p_attribute2_name => 'ATTRIBUTE2'

Line 697: from per_absence_cases

693: ) return date as
694: --
695: cursor c_abs_case_exists is
696: select absence_case_id
697: from per_absence_cases
698: where absence_case_id = p_absence_case_id;
699: --
700: cursor c_abs_list is
701: select min(date_start)

Line 745: from per_absence_cases

741: ) return date as
742: --
743: cursor c_abs_case_exists is
744: select absence_case_id
745: from per_absence_cases
746: where absence_case_id = p_absence_case_id;
747: --
748: cursor c_abs_list is
749: select max(date_end)