APPS.HR_WRK_SCH_PKG dependencies on PER_SCH_INHERIT_HIER

Line 43: FROM per_sch_inherit_hier

39:
40: -- Get max schedule inheritance level
41: CURSOR c_max_inh_seq IS
42: SELECT MAX(hier_seq)
43: FROM per_sch_inherit_hier
44: WHERE in_hier = 'Y'
45: AND hier_seq IS NOT NULL;
46:
47: -- Get schedule inheritance level from hierarchy

Line 50: FROM per_sch_inherit_hier

46:
47: -- Get schedule inheritance level from hierarchy
48: CURSOR c_sch_inh_lvl (cp_inh_seq IN NUMBER) IS
49: SELECT inherit_level
50: FROM per_sch_inherit_hier
51: WHERE hier_seq = cp_inh_seq;
52:
53: -- Cursor to get person assignment attributes
54: CURSOR c_per_asg (cp_per_asg_id IN NUMBER

Line 475: FROM per_sch_inherit_hier

471:
472: -- Get max schedule inheritance level
473: CURSOR c_max_inh_seq IS
474: SELECT MAX(hier_seq)
475: FROM per_sch_inherit_hier
476: WHERE in_hier = 'Y'
477: AND hier_seq IS NOT NULL;
478:
479: -- Get schedule inheritance level from hierarchy

Line 482: FROM per_sch_inherit_hier

478:
479: -- Get schedule inheritance level from hierarchy
480: CURSOR c_sch_inh_lvl (cp_inh_seq IN NUMBER) IS
481: SELECT inherit_level
482: FROM per_sch_inherit_hier
483: WHERE hier_seq = cp_inh_seq;
484:
485: -- Cursor to get person assignment attributes
486: CURSOR c_per_asg (cp_per_asg_id IN NUMBER