APPS.AHL_UC_UTILIZATION_PVT dependencies on AHL_CTR_UPDATE_RULES

Line 1558: FROM ahl_ctr_update_rules

1554: CURSOR ahl_ctr_rule_csr (c_relationship_id NUMBER,
1555: c_uom_code VARCHAR2,
1556: c_rule_code VARCHAR2) IS
1557: SELECT ratio
1558: FROM ahl_ctr_update_rules
1559: WHERE relationship_id = c_relationship_id
1560: AND rule_code = c_rule_code
1561: AND uom_code = c_uom_code;
1562:

Line 1578: l_rule_code ahl_ctr_update_rules.rule_code%TYPE := p_rule_code;

1574: AND relationship_type_code = 'COMPONENT-OF'
1575: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1576: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1577:
1578: l_rule_code ahl_ctr_update_rules.rule_code%TYPE := p_rule_code;
1579: l_ratio NUMBER;
1580: l_total_ratio NUMBER;
1581: l_position_ref NUMBER;
1582: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;

Line 1582: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;

1578: l_rule_code ahl_ctr_update_rules.rule_code%TYPE := p_rule_code;
1579: l_ratio NUMBER;
1580: l_total_ratio NUMBER;
1581: l_position_ref NUMBER;
1582: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;
1583: l_match_found_flag BOOLEAN;
1584: l_table_count NUMBER;
1585: l_posn_master_config_id NUMBER;
1586: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_Counter_Ratio';