APPS.FV_SLA_PROCESSING_PKG dependencies on PO_EXTRACT_DETAIL_V

Line 1036: FROM PO_EXTRACT_DETAIL_V ped, PO_BC_DISTRIBUTIONS pbd

1032:
1033: /*Get all the distribution ids in p_event_id event which belong to the same document*/
1034: CURSOR c_get_dist_ids IS
1035: SELECT pbd.distribution_id,pbd.code_combination_id,pbd.accounted_amt
1036: FROM PO_EXTRACT_DETAIL_V ped, PO_BC_DISTRIBUTIONS pbd
1037: WHERE ped.event_id = pbd.ae_event_id --p_event_id AND
1038: AND ped.po_distribution_id = pbd.distribution_id
1039: AND pbd.header_id = p_header_id
1040: AND pbd.main_or_backing_code = 'M';

Line 1621: FROM po_extract_detail_v

1617: where req_distribution_type = 'REQUISITION' ;
1618:
1619: CURSOR c_po_extract_detail IS
1620: SELECT *
1621: FROM po_extract_detail_v
1622: where po_distribution_type <> 'REQUISITION';
1623:
1624: CURSOR c_get_req_gl_date(p_event_id NUMBER) IS
1625: SELECT gl_date