APPS.PER_CPL_UPD dependencies on PER_COMPETENCES

Line 66: -- Update the per_competences_tl Row

62: --
63: --
64: --
65: --
66: -- Update the per_competences_tl Row
67: --
68: update per_competences_tl
69: set
70: competence_id = p_rec.competence_id

Line 68: update per_competences_tl

64: --
65: --
66: -- Update the per_competences_tl Row
67: --
68: update per_competences_tl
69: set
70: competence_id = p_rec.competence_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang

Line 225: (p_module_name => 'PER_COMPETENCES_TL'

221: --
222: when hr_api.cannot_find_prog_unit then
223: --
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'PER_COMPETENCES_TL'
226: ,p_hook_type => 'AU');
227: --
228: end;
229: --

Line 429: from per_competences_tl cpl

425: -- source_lang match the specified language.
426: --
427: cursor csr_upd_langs is
428: select cpl.language
429: from per_competences_tl cpl
430: where cpl.competence_id = p_competence_id
431: and p_language_code in (cpl.language
432: ,cpl.source_lang);
433: --

Line 479: , per_competences cpn

475: , l.nls_language
476: , cd.id_flex_num
477: , cd.competence_definition_id
478: from fnd_languages l
479: , per_competences cpn
480: , per_competence_definitions cd
481: where cpn.competence_id = p_competence_id
482: and cpn.competence_definition_id = cd.competence_definition_id
483: and l.installed_flag IN ('B', 'I');