APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_REQUISITION_HEADERS

Line 140: FROM po_requisition_headers prh,

136: ) RETURN VARCHAR2 AS
137:
138: CURSOR c_lock_req IS
139: SELECT 'x'
140: FROM po_requisition_headers prh,
141: po_requisition_lines prl,
142: po_req_distributions prd
143: WHERE prh.requisition_header_id = p_document_id
144: AND prh.requisition_header_id = prl.requisition_header_id

Line 1987: po_requisition_headers prh,

1983: gl_sets_of_books glsob,
1984: financials_system_parameters fsp,
1985: po_requisition_lines prl,
1986: po_req_distributions prd,
1987: po_requisition_headers prh,
1988: po_line_locations poll,
1989: po_distributions pod,
1990: po_lines pol
1991: WHERE

Line 2221: po_requisition_headers prh,

2217: gl_sets_of_books glsob,
2218: financials_system_parameters fsp,
2219: po_requisition_lines prl,
2220: po_req_distributions prd,
2221: po_requisition_headers prh,
2222: po_line_locations poll,
2223: po_distributions pod,
2224: po_lines pol
2225: WHERE

Line 2455: po_requisition_headers prh,

2451: gl_sets_of_books glsob,
2452: financials_system_parameters fsp,
2453: po_requisition_lines prl,
2454: po_req_distributions prd,
2455: po_requisition_headers prh,
2456: po_line_locations poll,
2457: po_distributions pod,
2458: po_lines pol
2459: WHERE

Line 2676: po_requisition_headers prh,

2672: gl_sets_of_books glsob,
2673: financials_system_parameters fsp,
2674: po_requisition_lines prl,
2675: po_req_distributions prd,
2676: po_requisition_headers prh,
2677: po_line_locations poll,
2678: po_distributions pod,
2679: po_lines pol
2680: WHERE

Line 3885: FROM po_requisition_headers

3881: SELECT authorization_status auth_status,
3882: closed_code,
3883: type_lookup_code document_subtype,
3884: cbc_accounting_date
3885: FROM po_requisition_headers
3886: WHERE requisition_header_id = p_req_id ;
3887:
3888: -- ssmales 7-Feb-03 Added conc_request_id clause to two cursors below - bug 2791502
3889: -- Bug 2803967,