APPS.PER_CPL_BUS dependencies on PER_COMPETENCES

Line 34: , per_competences cpn

30:
31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_competences cpn
35: , per_competences_tl cpl
36: where cpl.competence_id = p_competence_id
37: and pbg.business_group_id = cpn.business_group_id
38: and cpl.competence_id = cpn.competence_id;

Line 35: , per_competences_tl cpl

31: cursor csr_sec_grp is
32: select pbg.security_group_id
33: from per_business_groups pbg
34: , per_competences cpn
35: , per_competences_tl cpl
36: where cpl.competence_id = p_competence_id
37: and pbg.business_group_id = cpn.business_group_id
38: and cpl.competence_id = cpn.competence_id;
39: --

Line 103: , per_competences_tl cpl

99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , per_competences_tl cpl
104: , per_competences cpn
105: where cpl.competence_id = p_competence_id
106: and cpl.language = p_language
107: and cpl.competence_id = cpn.competence_id

Line 104: , per_competences cpn

100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , per_competences_tl cpl
104: , per_competences cpn
105: where cpl.competence_id = p_competence_id
106: and cpl.language = p_language
107: and cpl.competence_id = cpn.competence_id
108: and pbg.business_group_id = cpn.competence_id;

Line 232: -- it replaces (PER_COMPETENCES_UK3)

228: --
229: -- Description:
230: --
231: -- - Validates that it is unique within the table as per the constraint
232: -- it replaces (PER_COMPETENCES_UK3)
233: --
234: -- Pre_conditions:
235: -- None
236: --

Line 255: (p_competence_id in per_competences_tl.competence_id%TYPE

251: --
252: --
253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is

Line 256: ,p_language in per_competences_tl.language%TYPE

252: --
253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is
260: --

Line 257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE

253: --
254: procedure chk_alias
255: (p_competence_id in per_competences_tl.competence_id%TYPE
256: ,p_language in per_competences_tl.language%TYPE
257: ,p_competence_alias in per_competences_tl.competence_alias%TYPE
258: )
259: is
260: --
261: l_exists varchar2(1);

Line 269: from per_competences_tl pct

265: -- Cursor to check if competence_alias is unique
266: --
267: cursor csr_chk_alias is
268: select 'x'
269: from per_competences_tl pct
270: where (( p_competence_id is null)
271: or (p_competence_id <> pct.competence_id)
272: )
273: and language = p_language