DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_LIST_HEADERS_B

Line 47: FROM qp_list_headers_b

43:
44: CURSOR gsa_cur(a_list_header_id NUMBER)
45: IS
46: SELECT gsa_indicator
47: FROM qp_list_headers_b
48: WHERE list_header_id = a_list_header_id;
49:
50: CURSOR to_rltd_modifier_id_cur(a_list_line_id NUMBER,
51: a_rltd_modifier_grp_type VARCHAR2)

Line 731: FROM qp_list_headers_b h, qp_list_lines l

727:
728: -- We have to use list_line_id here because list_header_id has not been populated yet.
729: SELECT h.pte_code, h.source_system_code
730: INTO l_pte_code, l_ss_code
731: FROM qp_list_headers_b h, qp_list_lines l
732: WHERE l.list_line_id = p_PRICING_ATTR_rec.list_line_id
733: AND l.list_header_id = h.list_header_id;
734:
735: QP_UTIL.Get_Item_Cat_Info(