DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on SO_PRICING_RULES_VL

Line 1000: FROM so_pricing_rules_vl;

996: BEGIN
997: SELECT nvl(min(pricing_rule_id),0),
998: nvl(max(pricing_rule_id),0)
999: INTO l_min_line, l_max_line
1000: FROM so_pricing_rules_vl;
1001:
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: NULL;

Line 1080: FROM so_pricing_rules_vl

1076: CURSOR so_pricing_rules_cur (a_min_line NUMBER,
1077: a_max_line NUMBER)
1078: IS
1079: SELECT *
1080: FROM so_pricing_rules_vl
1081: WHERE pricing_rule_id BETWEEN a_min_line AND a_max_line;
1082:
1083: CURSOR so_pricing_rule_lines_cur (a_pricing_rule_id NUMBER)
1084: IS