eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_STAT_SIT_UTIL dependencies on PQH_FR_STAT_SITUATIONS_V

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 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 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