APPS.QP_DATA_COMPARE_PVT dependencies on QP_PATTERN_PHASES

Line 1656: FROM qp_pattern_phases

1652:
1653: CURSOR csr_get_pattern_phases(p_pricing_phase_id NUMBER,p_pattern_id NUMBER) IS
1654: SELECT pattern_id,
1655: pricing_phase_id
1656: FROM qp_pattern_phases
1657: WHERE pricing_phase_id = p_pricing_phase_id
1658: AND pattern_id = p_pattern_id;
1659:
1660: CURSOR csr_get_prod_pattern_phases(p_list_line_id NUMBER) IS

Line 1662: FROM qp_list_lines a , qp_pattern_phases b

1658: AND pattern_id = p_pattern_id;
1659:
1660: CURSOR csr_get_prod_pattern_phases(p_list_line_id NUMBER) IS
1661: SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
1662: FROM qp_list_lines a , qp_pattern_phases b
1663: WHERE a.list_line_id = p_list_line_id
1664: AND a.pattern_id = b.pattern_id
1665: AND a.pricing_phase_id = b.pricing_phase_id;
1666:

Line 1672: qp_pattern_phases c

1668: SELECT a.list_header_id,a.pattern_id,c.pricing_phase_id
1669: FROM qp_attribute_groups a ,
1670: (SELECT distinct list_header_id, pricing_phase_id
1671: FROM qp_list_lines WHERE list_line_id = p_list_line_id) b ,
1672: qp_pattern_phases c
1673: WHERE a.list_header_id = b.list_header_id
1674: AND a.pattern_id = c.pattern_id
1675: AND a.list_line_id = -1;
1676:

Line 1679: FROM qp_attribute_groups a, qp_pattern_phases b

1675: AND a.list_line_id = -1;
1676:
1677: CURSOR csr_get_lqual_pattern_phases(p_list_line_id NUMBER) IS
1678: SELECT a.list_header_id,a.pattern_id,a.pricing_phase_id
1679: FROM qp_attribute_groups a, qp_pattern_phases b
1680: WHERE a.list_line_id = p_list_line_id
1681: AND a.pattern_id = b.pattern_id
1682: AND a.pricing_phase_id = b.pricing_phase_id;
1683: