APPS.AHL_UC_UTILIZATION_PVT dependencies on AHL_CTR_UPDATE_RULES

Line 1589: FROM ahl_ctr_update_rules

1585: CURSOR ahl_ctr_rule_csr (c_relationship_id NUMBER,
1586: c_uom_code VARCHAR2,
1587: c_rule_code VARCHAR2) IS
1588: SELECT ratio
1589: FROM ahl_ctr_update_rules
1590: WHERE relationship_id = c_relationship_id
1591: AND rule_code = c_rule_code
1592: AND uom_code = c_uom_code;
1593:

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

1605: AND relationship_type_code = 'COMPONENT-OF'
1606: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1607: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1608:
1609: l_rule_code ahl_ctr_update_rules.rule_code%TYPE := p_rule_code;
1610: l_ratio NUMBER;
1611: l_total_ratio NUMBER;
1612: l_position_ref NUMBER;
1613: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;

Line 1613: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;

1609: l_rule_code ahl_ctr_update_rules.rule_code%TYPE := p_rule_code;
1610: l_ratio NUMBER;
1611: l_total_ratio NUMBER;
1612: l_position_ref NUMBER;
1613: l_uom_code ahl_ctr_update_rules.uom_code%TYPE;
1614: l_match_found_flag BOOLEAN;
1615: l_table_count NUMBER;
1616: l_posn_master_config_id NUMBER;
1617: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_Counter_Ratio';