APPS.PQH_PSU_BUS dependencies on PQH_FR_STAT_SITUATIONS

Line 31: , pqh_fr_stat_situations sts

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pqh_fr_stat_situations sts
32: where
33: sts.statutory_situation_id = p_statutory_situation_id
34: and pbg.business_group_id = sts.business_group_id;
35: --

Line 103: , pqh_fr_stat_situations sts

99: cursor csr_leg_code is
100: select pbg.legislation_code
101: from per_business_groups_perf pbg
102: , pqh_fr_emp_stat_situations psu
103: , pqh_fr_stat_situations sts
104: where psu.emp_stat_situation_id = p_emp_stat_situation_id
105: and psu.statutory_situation_id = sts.statutory_situation_id
106: and pbg.business_group_id = sts.business_group_id;
107: --

Line 443: FROM pqh_fr_stat_situations

439: -- ----------------------------------------------------------------------------
440: Procedure chk_statutory_situation(p_statutory_situation_id IN NUMBER) IS
441: CURSOR csr_valid_stat_sit(p_statutory_situation_id IN NUMBER) IS
442: SELECT 'X'
443: FROM pqh_fr_stat_situations
444: WHERE statutory_situation_id = p_statutory_situation_id
445: AND TRUNC(SYSDATE) BETWEEN date_from and NVL(date_to,TRUNC(SYSDATE));
446: l_valid_sit varchar2(10);
447: BEGIN

Line 474: FROM pqh_fr_stat_situations

470: NVL(renewable_allowed,'N'),
471: NVL(max_no_of_renewals,0),
472: NVL(max_duration_per_renewal,0),
473: NVL(max_tot_continuous_duration,0)
474: FROM pqh_fr_stat_situations
475: WHERE statutory_situation_id = p_rec.statutory_situation_id;
476: --
477: --Cursor to fetch continous renewal duration,
478: CURSOR csr_cont_renewals(p_date DATE) IS

Line 585: FROM pqh_fr_stat_situations

581: NVL(renewable_allowed,'N'),
582: max_no_of_renewals,
583: max_duration_per_renewal,
584: max_tot_continuous_duration
585: FROM pqh_fr_stat_situations
586: WHERE statutory_situation_id = p_rec.statutory_situation_id;
587: --
588: --Cursor to fetch continous renewal duration,
589: CURSOR csr_cont_renewals(p_date DATE) IS

Line 736: from pqh_fr_stat_situations

732: and trunc(sysdate) between effective_start_date and effective_end_date;
733: --
734: Cursor csr_situation_info IS
735: Select nvl(date_to,hr_general.end_of_time)
736: from pqh_fr_stat_situations
737: where statutory_situation_id = p_statutory_situation_id;
738: l_original_hire_date date;
739: l_situ_end_date date;
740: Begin

Line 777: FROM pqh_fr_stat_situations

773: --
774: CURSOR csr_default_sit IS
775: SELECT 'x' FROM DUAL
776: WHERE EXISTS(SELECT statutory_situation_id
777: FROM pqh_fr_stat_situations
778: WHERE statutory_situation_id = p_rec.statutory_situation_id
779: AND situation_type = 'IA'
780: AND sub_type = 'IA_N'
781: AND business_group_id = HR_GENERAL.get_business_group_id

Line 800: FROM pqh_fr_stat_situations_v sit,

796: AND emp_stat_situation_id <> NVL(p_emp_stat_situation_id,-1)
797: -- AND NVL(renew_stat_situation_id,-2) <> NVL(p_emp_stat_situation_id,-1) --commented by deenath
798: AND statutory_situation_id <>
799: (SELECT statutory_situation_id
800: FROM pqh_fr_stat_situations_v sit,
801: per_shared_types_vl sh
802: WHERE sh.shared_type_id = type_of_ps
803: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
804: AND sit.business_group_id = HR_GENERAL.get_business_group_id

Line 910: FROM pqh_fr_stat_situations

906: first_period_max_duration,
907: min_duration_per_request,
908: max_duration_per_request,
909: max_duration_whole_career
910: FROM pqh_fr_stat_situations
911: WHERE statutory_situation_id = p_rec.statutory_situation_id;
912: --
913: --Cursor to fetch total duration for the person. Modified by deenath added emp_stat_sit clause.
914: CURSOR csr_duration_days IS

Line 1030: FROM pqh_fr_stat_situations

1026: first_period_max_duration,
1027: max_duration_whole_career,
1028: max_duration_per_request,
1029: min_duration_per_request
1030: FROM pqh_fr_stat_situations
1031: WHERE statutory_situation_id = p_rec.statutory_situation_id;
1032: --
1033: --Cursor to fetch total duration for the person. Modified by deenath added emp_stat_sit clause.
1034: CURSOR csr_duration_days IS