APPS.HR_AMM_BUS dependencies on BEN_PL_F

Line 109: -- Validates that a pl_id exists in the table ben_pl_f

105: -- |------------------------------< chk_pl_id >-------------------------------|
106: -- ----------------------------------------------------------------------------
107: --
108: -- Description :
109: -- Validates that a pl_id exists in the table ben_pl_f
110: --
111: -- Pre-conditions:
112: -- None
113: --

Line 118: -- If a row does exist in ben_pl_f for the given pl_id then

114: -- In Arguments :
115: -- p_pl_id
116: --
117: -- Post Success :
118: -- If a row does exist in ben_pl_f for the given pl_id then
119: -- processing continues
120: --
121: -- Post Failure :
122: -- If a row does not exist in ben_pl_f for the given pl_id then

Line 122: -- If a row does not exist in ben_pl_f for the given pl_id then

118: -- If a row does exist in ben_pl_f for the given pl_id then
119: -- processing continues
120: --
121: -- Post Failure :
122: -- If a row does not exist in ben_pl_f for the given pl_id then
123: -- an application error will be raised and processing is terminated
124: --
125: -- Access Status :
126: -- Internal Table Handler Use only.

Line 138: from ben_pl_f

134: l_proc varchar2(72) := g_package||'chk_pl_id';
135: --
136: cursor csr_valid_plan is
137: select 'Y'
138: from ben_pl_f
139: where pl_id = p_pl_id;
140: --
141: begin
142: hr_utility.set_location('Entering: '|| l_proc, 1);

Line 154: -- Check that the pl_id is in ben_pl_f

150: );
151: --
152: hr_utility.set_location(l_proc, 2);
153: --
154: -- Check that the pl_id is in ben_pl_f
155: --
156: open csr_valid_plan;
157: fetch csr_valid_plan into l_exists;
158: if csr_valid_plan%notfound then