APPS.PQH_FR_STAT_SIT_UTIL dependencies on PQH_FR_EMP_STAT_SITUATIONS

Line 258: from PQH_FR_EMP_STAT_SITUATIONS ess, PQH_FR_STAT_SITUATIONS_V ss

254: p_determination_date IN DATE) return varchar2
255: IS
256: cursor csr_situation_info is
257: select ss.situation_type, ss.situation_name, ss.situation_type_name
258: from PQH_FR_EMP_STAT_SITUATIONS ess, PQH_FR_STAT_SITUATIONS_V ss
259: where ess.Statutory_situation_id = ss.Statutory_situation_id
260: and ess.person_id = p_person_id
261: and p_determination_date between ess.actual_start_date and nvl(ess.actual_end_date, ess.provisional_end_date);
262:

Line 350: FROM pqh_fr_emp_stat_situations

346: --
347: Function is_current_situation(p_emp_stat_situation_id NUMBER) RETURN varchar2 IS
348: Cursor Csr_current_situation(p_emp_statutory_situation_id NUMBER) IS
349: SELECT NVL(actual_start_date,provisional_start_date),NVL(NVL(actual_end_date,provisional_end_date),TRUNC(SYSDATE)),NVL(approval_flag,'N')
350: FROM pqh_fr_emp_stat_situations
351: WHERE emp_stat_situation_id = p_emp_stat_situation_id;
352: l_start_date DATE;
353: l_end_date DATE;
354: l_approved varchar2(10);

Line 368: FROM pqh_fr_emp_stat_situations

364: --
365: FUNCTION get_number_of_renewals(p_emp_stat_situation_id NUMBER) RETURN NUMBER IS
366: CURSOR csr_no_of_renewals(p_emp_stat_situation_id IN NUMBER) IS
367: SELECT NVL(count(emp_stat_situation_id),0)
368: FROM pqh_fr_emp_stat_situations
369: WHERE renewal_flag = 'Y'
370: AND renew_stat_situation_id = p_emp_stat_situation_id;
371: l_no_of_renewals NUMBER(10) := 0;
372: BEGIN

Line 387: FROM pqh_fr_emp_stat_situations

383: --
384: --Cursor to fetch total number of renewals.
385: CURSOR csr_no_of_renewals IS
386: SELECT NVL(COUNT(emp_stat_situation_id),0)
387: FROM pqh_fr_emp_stat_situations
388: WHERE emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)
389: AND renewal_flag = 'Y'
390: AND renew_stat_situation_id = p_renew_stat_situation_id;
391: --

Line 737: FROM pqh_fr_emp_stat_situations

733: ELSIF p_provisional_start_date > p_effective_date THEN
734: --added by deenath
735: SELECT DECODE(TRUNC(MAX(provisional_start_date)),TRUNC(p_provisional_start_date),'DEL-TRUE',NULL)
736: INTO l_return_value
737: FROM pqh_fr_emp_stat_situations
738: WHERE person_id = p_person_id
739: AND statutory_situation_id NOT IN (SELECT statutory_situation_id
740: FROM pqh_fr_stat_situations_v sit
741: ,per_shared_types_vl sh