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 1986: po_requisition_headers prh,

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

Line 2220: po_requisition_headers prh,

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

Line 2454: po_requisition_headers prh,

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

Line 2675: po_requisition_headers prh,

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

Line 3884: FROM po_requisition_headers

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