DBA Data[Home] [Help]

APPS.AS_FOUNDATION_PVT dependencies on AS_PRICE_LISTS

Line 1182: --FROM as_price_lists apl, oe_price_lists spl

1178: p_currency_code IN VARCHAR2,
1179: x_price_list_id OUT NOCOPY NUMBER) IS
1180: CURSOR l_price_list_id_csr (c_group_id NUMBER, c_currency_code VARCHAR2) IS
1181: SELECT apl.price_list_id
1182: --FROM as_price_lists apl, oe_price_lists spl
1183: FROM as_price_lists apl, qp_price_lists_v spl
1184: WHERE apl.group_id = c_group_id
1185: AND apl.price_list_id = spl.price_list_id
1186: AND spl.currency_code = c_currency_code;

Line 1183: FROM as_price_lists apl, qp_price_lists_v spl

1179: x_price_list_id OUT NOCOPY NUMBER) IS
1180: CURSOR l_price_list_id_csr (c_group_id NUMBER, c_currency_code VARCHAR2) IS
1181: SELECT apl.price_list_id
1182: --FROM as_price_lists apl, oe_price_lists spl
1183: FROM as_price_lists apl, qp_price_lists_v spl
1184: WHERE apl.group_id = c_group_id
1185: AND apl.price_list_id = spl.price_list_id
1186: AND spl.currency_code = c_currency_code;
1187: