DBA Data[Home] [Help]

APPS.PER_SIT_PKG dependencies on PER_ANALYSIS_CRITERIA

Line 511: from per_analysis_criteria ac

507: p_category in varchar2) return boolean is
508: --
509: cursor c_job_requirement is
510: select 'X'
511: from per_analysis_criteria ac
512: , per_job_requirements jr
513: where ac.id_flex_num = p_id_flex_num
514: and jr.analysis_criteria_id = ac.analysis_criteria_id
515: and jr.business_group_id = p_business_group_id --bug 3648683

Line 520: from per_analysis_criteria ac

516: and jr.job_id is not null;
517: --
518: cursor c_position_requirement is
519: select 'X'
520: from per_analysis_criteria ac
521: , per_job_requirements jr
522: where ac.id_flex_num = p_id_flex_num
523: and jr.analysis_criteria_id = ac.analysis_criteria_id
524: and jr.business_group_id = p_business_group_id --bug 3648683