APPS.PERCOMPSTATUS dependencies on PER_COMPETENCE_OUTCOMES

Line 17: FROM per_comp_element_outcomes ceo , per_competence_outcomes pco

13: ,p_eff_date in date default trunc(sysdate)
14: ) return VARCHAR2 is
15: CURSOR getEndDatedOutcomes(compEleId IN Number) is
16: Select max(ceo.date_to),ceo.outcome_id
17: FROM per_comp_element_outcomes ceo , per_competence_outcomes pco
18: where competence_element_id = compEleId
19: AND ceo.date_to < p_eff_date
20: and pco.outcome_id = ceo.outcome_id
21: and pco.date_from <= p_eff_date

Line 108: hr_api_transaction_values tv3, per_competence_outcomes pco

104: Select count(*) INTO l_noof_outcomes
105: FROM hr_api_transaction_steps ts,
106: hr_api_transaction_values tv,
107: hr_api_transaction_values tv1, hr_api_transaction_values tv2,
108: hr_api_transaction_values tv3, per_competence_outcomes pco
109: Where ts.ITEM_TYPE = p_item_type
110: AND ts.item_key = p_item_key
111: And ts.activity_id = nvl(to_number(p_activity_id),ts.activity_id)
112: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'

Line 143: per_competence_outcomes pco

139:
140:
141: -- END for the 4187713 bug.
142: Select count(*) INTO l_noof_outcomes from
143: per_competence_outcomes pco
144: WHERE competence_id = p_competence_id
145: AND nvl(p_eff_date,trunc(sysdate)) BETWEEN date_from AND nvl(date_to,nvl(p_eff_date,trunc(sysdate)))
146: AND NOT EXISTS ( (Select 1 FROM per_comp_element_outcomes
147: Where competence_element_id = p_competence_element_id

Line 184: per_competence_outcomes pco

180: And trunc(p_eff_date) BETWEEN tv1.date_value
181: AND nvl(tv2.date_value,trunc(p_eff_date))));
182: else
183: Select count(*) INTO l_noof_outcomes from
184: per_competence_outcomes pco
185: Where pco.Competence_id = p_competence_id
186: AND pco.date_from <= p_eff_date
187: AND nvl(pco.date_to,p_eff_date) >= p_eff_date;
188: END if;

Line 253: per_competence_outcomes pco

249: RETURN l_comp_status;
250: END if;
251: Select count(*) INTO l_noof_outcomes
252: from
253: per_competence_outcomes pco
254: WHERE pco.competence_id = p_competence_id
255: AND nvl(p_eff_date,sysdate) BETWEEN pco.date_from AND nvl(pco.date_to,nvl(p_eff_date,trunc(sysdate)))
256: AND NOT exists (Select 1 FROM hr_api_transaction_values tv,
257: hr_api_transaction_values tv1, hr_api_transaction_values tv2,

Line 296: hr_api_transaction_values tv3, per_competence_outcomes pco

292: Select count(*) INTO l_noof_outcomes
293: FROM hr_api_transaction_steps ts,
294: hr_api_transaction_values tv,
295: hr_api_transaction_values tv1, hr_api_transaction_values tv2,
296: hr_api_transaction_values tv3, per_competence_outcomes pco
297: Where ts.ITEM_TYPE = p_item_type
298: AND ts.item_key = p_item_key
299: And ts.activity_id = nvl(to_number(p_activity_id),ts.activity_id)
300: AND ts.API_NAME = 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API'