APPS.BEN_BCM_BUS dependencies on BEN_CWB_MATRIX

Line 31: , ben_cwb_matrix bcm

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ben_cwb_matrix bcm
32: where bcm.cwb_matrix_id = p_cwb_matrix_id
33: and pbg.business_group_id = bcm.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ben_cwb_matrix bcm

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ben_cwb_matrix bcm
102: where bcm.cwb_matrix_id = p_cwb_matrix_id
103: and pbg.business_group_id = bcm.business_group_id;
104: --
105: -- Declare local variables

Line 268: (p_lookup_type => 'BEN_CWB_MATRIX_ROW_CRITERIA',

264: --
265: -- check if value of lookup falls within lookup type.
266: --
267: if hr_api.not_exists_in_hr_lookups
268: (p_lookup_type => 'BEN_CWB_MATRIX_ROW_CRITERIA',
269: p_lookup_code => p_row_crit_cd,
270: p_effective_date => p_effective_date) then
271: --
272: -- raise error as does not exist as lookup

Line 276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');

272: -- raise error as does not exist as lookup
273: --
274: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
275: fnd_message.set_token('FIELD', p_row_crit_cd);
276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');
277: fnd_message.raise_error;
278: --
279: end if;
280: --

Line 292: (p_lookup_type => 'BEN_CWB_MATRIX_COLUMN_CRITERIA',

288: --
289: -- check if value of lookup falls within lookup type.
290: --
291: if hr_api.not_exists_in_hr_lookups
292: (p_lookup_type => 'BEN_CWB_MATRIX_COLUMN_CRITERIA',
293: p_lookup_code => p_col_crit_cd,
294: p_effective_date => p_effective_date) then
295: --
296: -- raise error as does not exist as lookup

Line 300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');

296: -- raise error as does not exist as lookup
297: --
298: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
299: fnd_message.set_token('FIELD', p_col_crit_cd);
300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');
301: fnd_message.raise_error;
302: --
303: end if;
304: --