APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PTE_SOURCE_SYSTEMS

Line 1801: FROM qp_pte_source_systems

1797: AND nvl(active_flag, 'N') = 'Y'
1798: AND (global_flag = 'Y' OR
1799: orig_org_id = p_pb_input_header_rec.org_id)
1800: AND source_system_code IN (SELECT application_short_name
1801: FROM qp_pte_source_systems
1802: WHERE pte_code = l_pte_code)
1803: AND list_header_id = p_pb_input_header_rec.pl_agr_bsa_id
1804: AND rownum = 1;
1805: EXCEPTION

Line 1882: FROM qp_pte_source_systems

1878: AND nvl(active_flag, 'N') = 'Y'
1879: AND (global_flag = 'Y' OR
1880: orig_org_id = p_pb_input_header_rec.org_id)
1881: AND source_system_code IN (SELECT application_short_name
1882: FROM qp_pte_source_systems
1883: WHERE pte_code = l_pte_code)
1884: AND list_header_id = p_pb_input_header_rec.pl_agr_bsa_id
1885: AND rownum = 1;
1886: EXCEPTION

Line 1927: FROM qp_pte_source_systems

1923: AND (global_flag = 'Y' OR
1924: orig_org_id = p_pb_input_header_rec.org_id)
1925: AND source_system_code IN
1926: (SELECT application_short_name
1927: FROM qp_pte_source_systems
1928: WHERE pte_code = l_pte_code)
1929: )
1930: AND (trunc(nvl(p_pb_input_header_rec.effective_date, sysdate))
1931: between trunc(nvl(start_date_active,