APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_CTR_UPDATE_RULES

Line 2831: FROM ahl_ctr_update_rules

2827:
2828: -- for counter rules given a relationship_id.
2829: CURSOR ahl_ctr_rule_csr ( p_relationship_id IN NUMBER) IS
2830: SELECT uom_code, ratio
2831: FROM ahl_ctr_update_rules
2832: WHERE relationship_id = p_relationship_id
2833: AND rule_code = 'STANDARD';
2834:
2835: -- traverse up the master configuration to top node.

Line 2871: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;

2867: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate + 1));
2868:
2869:
2870: l_position_ref NUMBER;
2871: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;
2872: l_ratio NUMBER;
2873: l_match_found_flag BOOLEAN;
2874: l_table_count NUMBER;
2875: l_posn_master_config_id NUMBER;