APPS.PQH_STS_BUS dependencies on PQH_FR_STAT_SITUATIONS

Line 33: , pqh_fr_stat_situations sts

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

Line 112: , pqh_fr_stat_situations sts

108: --
109: cursor csr_leg_code is
110: select pbg.legislation_code
111: from per_business_groups_perf pbg
112: , pqh_fr_stat_situations sts
113: where sts.statutory_situation_id = p_statutory_situation_id
114: and pbg.business_group_id = sts.business_group_id;
115: --
116: -- Declare local variables

Line 875: from pqh_fr_stat_situations

871: --
872: -- Situation Type + Type of PS + BG
873: Cursor csr_chk_default IS
874: Select null
875: from pqh_fr_stat_situations
876: where
877: type_of_ps = p_rec.type_Of_ps
878: and situation_type = p_rec.situation_type
879: and statutory_situation_id <> nvl(p_rec.statutory_situation_id,-1)

Line 994: from pqh_fr_stat_situations

990: l_value varchar2(1000);
991: --
992: Cursor csr_situation_name IS
993: Select situation_name
994: from pqh_fr_stat_situations
995: where situation_name = p_rec.situation_name
996: and business_group_id = p_rec.business_group_id
997: and statutory_situation_id <> nvl(p_rec.statutory_situation_id,-1);
998: --

Line 1036: from pqh_fr_stat_situations

1032: l_value varchar2(1000);
1033: --
1034: Cursor csr_unique_situation IS
1035: Select null
1036: from pqh_fr_stat_situations
1037: where
1038: type_of_ps = p_rec.type_Of_ps
1039: and situation_type = p_rec.situation_type
1040: and nvl(sub_type,'-1') = nvl(p_rec.sub_type,'-1')