APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_BUYERS_VAL_V

Line 5854: PO_BUYERS_V POB -- Replace PO_BUYERS_VAL_V with PO_BUYERS_V

5850: 'PO_BUYER_INACTIVE'
5851: FROM dual
5852: where not exists (select 'inactive buyer'
5853: from PO_RELEASES_GT POR,
5854: PO_BUYERS_V POB -- Replace PO_BUYERS_VAL_V with PO_BUYERS_V
5855: where por.agent_id = pob.employee_id);
5856:
5857:
5858:

Line 8146: PO_BUYERS_V POB -- Replace PO_BUYERS_VAL_V with PO_BUYERS_V

8142: 'PO_BUYER_INACTIVE'
8143: FROM dual
8144: where not exists (select 'inactive buyer'
8145: from PO_HEADERS_GT POH,
8146: PO_BUYERS_V POB -- Replace PO_BUYERS_VAL_V with PO_BUYERS_V
8147: where poh.agent_id = pob.employee_id);
8148:
8149: --Increment the p_sequence with number of errors reported in last query
8150: p_sequence := p_sequence + SQL%ROWCOUNT;

Line 22082: from PO_BUYERS_VAL_V POB

22078: IF p_contracting_officer IS NOT NULL THEN
22079: BEGIN
22080: select 'Y'
22081: into l_valid_co
22082: from PO_BUYERS_VAL_V POB
22083: where pob.employee_id = p_contracting_officer;
22084: EXCEPTION
22085: WHEN OTHERS THEN
22086: l_valid_co := 'N';