APPS.PQH_FR_STAT_SIT_UTIL dependencies on PQH_FR_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 263: l_situation_type pqh_fr_stat_situations_v.situation_type%TYPE ;

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:
263: l_situation_type pqh_fr_stat_situations_v.situation_type%TYPE ;
264: l_situation_name pqh_fr_stat_situations_v.situation_name%TYPE ;
265: l_situation_type_name pqh_fr_stat_situations_v.situation_type_name%TYPE ;
266:
267: begin

Line 264: l_situation_name pqh_fr_stat_situations_v.situation_name%TYPE ;

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:
263: l_situation_type pqh_fr_stat_situations_v.situation_type%TYPE ;
264: l_situation_name pqh_fr_stat_situations_v.situation_name%TYPE ;
265: l_situation_type_name pqh_fr_stat_situations_v.situation_type_name%TYPE ;
266:
267: begin
268: open csr_situation_info;

Line 265: l_situation_type_name pqh_fr_stat_situations_v.situation_type_name%TYPE ;

261: and p_determination_date between ess.actual_start_date and nvl(ess.actual_end_date, ess.provisional_end_date);
262:
263: l_situation_type pqh_fr_stat_situations_v.situation_type%TYPE ;
264: l_situation_name pqh_fr_stat_situations_v.situation_name%TYPE ;
265: l_situation_type_name pqh_fr_stat_situations_v.situation_type_name%TYPE ;
266:
267: begin
268: open csr_situation_info;
269: fetch csr_situation_info into l_situation_type, l_situation_name, l_situation_type_name;

Line 314: FROM pqh_fr_stat_situations

310: p_statutory_situation_id NUMBER) RETURN VARCHAR2 IS
311: --
312: CURSOR csr_renewable(p_statutory_situation_id NUMBER) IS
313: SELECT NVL(renewable_allowed,'N'),NVL(max_no_of_renewals,0)
314: FROM pqh_fr_stat_situations
315: WHERE statutory_situation_id = p_statutory_situation_id;
316: --
317: l_renewable Varchar2(10);
318: l_max_renewals NUMBER(10) := 0;

Line 605: FROM pqh_fr_stat_situations_v sit

601: p_situation_type IN VARCHAR2,
602: p_sub_type IN VARCHAR2,
603: p_eff_date IN DATE) IS
604: SELECT statutory_situation_id
605: FROM pqh_fr_stat_situations_v sit
606: ,per_shared_types_vl sh
607: WHERE sh.shared_type_id = type_of_ps
608: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
609: AND sit.business_group_id = p_business_group_id

Line 616: FROM pqh_fr_stat_situations

612: AND sit.default_flag = 'Y'
613: AND TRUNC(p_eff_date) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time);
614: /* --Commented by deenath and replaced by above cursor sql.
615: SELECT statutory_situation_id
616: FROM pqh_fr_stat_situations
617: WHERE business_group_id = p_business_group_id
618: AND situation_type = p_situation_type
619: AND sub_type = NVL(p_sub_type,sub_type)
620: AND default_flag = 'Y'

Line 740: FROM pqh_fr_stat_situations_v sit

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
742: WHERE sh.shared_type_id = type_of_ps
743: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
744: AND sit.business_group_id= HR_GENERAL.get_business_group_id