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 3867: FROM po_releases

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

Line 3892: FROM po_releases por,

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

Line 3929: FROM po_releases por,

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