APPS.QP_VALIDATE_MODIFIERS dependencies on QP_PRICING_PHASES

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

1680: OE_MSG_PUB.Add;
1681:
1682: END IF;
1683:
1684: /* Validate the Phase from qp_pricing_phases table */
1685:
1686: IF p_MODIFIERS_rec.pricing_phase_id IS NOT NULL
1687: THEN
1688: BEGIN

Line 1691: FROM QP_PRICING_PHASES

1687: THEN
1688: BEGIN
1689: SELECT phase_sequence, nvl(modifier_level_code,'*')
1690: INTO l_phase_sequence, l_modifier_level_code
1691: FROM QP_PRICING_PHASES
1692: WHERE nvl(LIST_TYPE_CODE,l_list_type_code) = l_list_type_code
1693: AND nvl(LIST_LINE_TYPE_CODE,p_MODIFIERS_rec.list_line_type_code) =
1694: p_MODIFIERS_rec.list_line_type_code
1695: AND nvl(MODIFIER_LEVEL_CODE,p_MODIFIERS_rec.modifier_level_code) =

Line 1718: FROM QP_PRICING_PHASES

1714: l_modifier_level_code = 'LINE' THEN
1715: /* BEGIN
1716: SELECT phase_sequence
1717: INTO l_phase_sequence
1718: FROM QP_PRICING_PHASES
1719: WHERE PRICING_PHASE_ID = p_MODIFIERS_rec.pricing_phase_id
1720: AND nvl(MODIFIER_LEVEL_CODE, '*') <> 'LINE';
1721: EXCEPTION
1722: WHEN NO_DATA_FOUND THEN */

Line 1778: from qp_pricing_phases

1774:
1775: IF (p_MODIFIERS_rec.list_line_type_code = 'PRG') THEN
1776: begin
1777: select 'Y' into l_phase_freeze_set
1778: from qp_pricing_phases
1779: where nvl(user_freeze_override_flag,freeze_override_flag) = 'Y'
1780: and pricing_phase_id = p_MODIFIERS_rec.PRICING_PHASE_ID;
1781: exception
1782: WHEN no_data_found THEN