DBA Data[Home] [Help]

APPS.PQH_STR_BUS dependencies on PQH_FR_STAT_SITUATIONS

Line 35: , pqh_fr_stat_situations sts

31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , pqh_fr_stat_situation_rules str
35: , pqh_fr_stat_situations sts
36: where str.stat_situation_rule_id = p_stat_situation_rule_id
37: and str.statutory_situation_id = sts.statutory_situation_id
38: and pbg.business_group_id = sts.business_group_id;
39: --

Line 117: , pqh_fr_stat_situations sts

113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups_perf pbg
116: , pqh_fr_stat_situation_rules str
117: , pqh_fr_stat_situations sts
118: where str.stat_situation_rule_id = p_stat_situation_rule_id
119: and pbg.business_group_id = sts.business_group_id
120: and sts.statutory_situation_id = str.statutory_situation_id;
121: --