APPS.PQH_FR_STAT_SIT_UTIL dependencies on PQH_FR_STAT_SITUATION_RULES

Line 55: from pqh_fr_stat_situation_rules

51: -- Declare Cursors
52: --
53: Cursor csr_get_situation_rule IS
54: Select txn_category_attribute_id, from_value , to_value
55: from pqh_fr_stat_situation_rules
56: where stat_situation_rule_id = p_stat_situation_rule_id;
57: --
58: -- Declare Local Variables
59: --

Line 170: from pqh_fr_stat_situation_rules

166: --
167: --
168: Cursor csr_rules_list IS
169: Select null
170: from pqh_fr_stat_situation_rules
171: where statutory_situation_id = p_stat_situation_id;
172: --
173: l_value varchar2(1);
174: l_return varchar2(10) := 'Y';

Line 522: FROM pqh_fr_stat_situation_rules

518: SELECT txn_category_attribute_id,
519: from_value,
520: to_value,
521: exclude_flag
522: FROM pqh_fr_stat_situation_rules
523: WHERE statutory_situation_id = p_stat_sit_id
524: AND NVL(enabled_flag,'N') = 'Y'
525: AND NVL(required_flag,'N') = p_required_flag
526: ORDER BY processing_sequence;