APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_RELEASES

Line 163: FROM po_releases por,

159: FOR UPDATE NOWAIT;
160:
161: CURSOR c_lock_release IS
162: SELECT 'x'
163: FROM po_releases por,
164: po_line_locations poll,
165: po_distributions pod
166: WHERE por.po_release_id = p_document_id
167: AND por.po_release_id = poll.po_release_id

Line 3868: FROM po_releases

3864: hold_flag,
3865: release_type document_subtype,
3866: frozen_flag,
3867: cbc_accounting_date
3868: FROM po_releases
3869: WHERE po_release_id = p_release_id ;
3870:
3871: CURSOR c_get_po_headers(p_header_id NUMBER) IS
3872: SELECT authorization_status auth_status,

Line 3893: FROM po_releases por,

3889: -- Bug 2803967,
3890: -- Removed the clause "AND ipe.exception_code = 'IGC_PO_YEP_REL_INV_STATE'"
3891: CURSOR c_get_release_errors(p_header_id NUMBER) IS
3892: SELECT 'x'
3893: FROM po_releases por,
3894: igc_cbc_po_process_excpts_all ipe
3895: WHERE por.po_header_id = p_header_id
3896: AND ipe.document_type = 'REL'
3897: AND ipe.document_id = por.po_release_id

Line 3930: FROM po_releases por,

3926: );
3927:
3928: CURSOR c_get_release_future(p_header_id NUMBER) IS
3929: SELECT 'x'
3930: FROM po_releases por,
3931: po_distributions pod
3932: WHERE por.po_header_id = p_header_id
3933: AND por.po_release_id = pod.po_release_id
3934: AND pod.gl_encumbered_date >= p_curr_year_start_date