DBA Data[Home] [Help]

APPS.PER_JBR_BUS dependencies on PER_JOB_REQUIREMENTS

Line 66: from per_job_requirements pjr

62: and pj.business_group_id + 0 = p_business_group_id;
63: --
64: cursor csr_combo_exists is
65: select 'x'
66: from per_job_requirements pjr
67: where (p_job_requirement_id <> pjr.job_requirement_id or
68: p_job_requirement_id is NULL)
69: and p_job_id = pjr.job_id
70: and p_analysis_criteria_id = pjr.analysis_criteria_id;

Line 175: from per_job_requirements pjr

171: and pos.business_group_id + 0 = p_business_group_id;
172: --
173: cursor csr_pos_combo_exists is
174: select 'x'
175: from per_job_requirements pjr
176: where (p_job_requirement_id <> pjr.job_requirement_id or
177: p_job_requirement_id is NULL)
178: and p_position_id = pjr.position_id
179: and p_analysis_criteria_id = pjr.analysis_criteria_id;

Line 536: ,p_descflex_name => 'PER_JOB_REQUIREMENTS'

532: -- b) During insert.
533: --
534: hr_dflex_utility.ins_or_upd_descflex_attribs
535: (p_appl_short_name => 'PER'
536: ,p_descflex_name => 'PER_JOB_REQUIREMENTS'
537: ,p_attribute_category => p_rec.attribute_category
538: ,p_attribute1_name => 'ATTRIBUTE1'
539: ,p_attribute1_value => p_rec.attribute1
540: ,p_attribute2_name => 'ATTRIBUTE2'