APPS.QP_VALIDATE_MODIFIERS dependencies on QP_PRICING_PHASES

Line 1694: /* Validate the Phase from qp_pricing_phases table */

1690: OE_MSG_PUB.Add;
1691:
1692: END IF;
1693:
1694: /* Validate the Phase from qp_pricing_phases table */
1695:
1696: IF p_MODIFIERS_rec.pricing_phase_id IS NOT NULL
1697: THEN
1698: BEGIN

Line 1701: FROM QP_PRICING_PHASES

1697: THEN
1698: BEGIN
1699: SELECT phase_sequence, nvl(modifier_level_code,'*')
1700: INTO l_phase_sequence, l_modifier_level_code
1701: FROM QP_PRICING_PHASES
1702: WHERE nvl(LIST_TYPE_CODE,l_list_type_code) = l_list_type_code
1703: AND nvl(LIST_LINE_TYPE_CODE,p_MODIFIERS_rec.list_line_type_code) =
1704: p_MODIFIERS_rec.list_line_type_code
1705: AND nvl(MODIFIER_LEVEL_CODE,p_MODIFIERS_rec.modifier_level_code) =

Line 1728: FROM QP_PRICING_PHASES

1724: l_modifier_level_code = 'LINE' THEN
1725: /* BEGIN
1726: SELECT phase_sequence
1727: INTO l_phase_sequence
1728: FROM QP_PRICING_PHASES
1729: WHERE PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id
1730: AND nvl(MODIFIER_LEVEL_CODE, '*') <> 'LINE';
1731: EXCEPTION
1732: WHEN NO_DATA_FOUND THEN */

Line 1788: from qp_pricing_phases

1784:
1785: IF (p_MODIFIERS_rec.list_line_type_code = 'PRG') THEN
1786: begin
1787: select 'Y' into l_phase_freeze_set
1788: from qp_pricing_phases
1789: where nvl(user_freeze_override_flag,freeze_override_flag) = 'Y'
1790: and pricing_phase_id = p_MODIFIERS_rec.PRICING_PHASE_ID;
1791: exception
1792: WHEN no_data_found THEN