APPS.IGC_CC_REVALUE_PROCESS_PKG dependencies on PO_HEADERS_ALL

Line 3932: FROM po_headers_all

3928:
3929: BEGIN
3930: SELECT count(po_header_id)
3931: INTO l_po_count
3932: FROM po_headers_all
3933: WHERE segment1 = l_cc_headers_rec.cc_num AND
3934: org_id = l_cc_headers_rec.org_id AND
3935: type_lookup_code = 'STANDARD' ;
3936: EXCEPTION

Line 3963: UPDATE po_headers_all

3959: IF (l_state_level >= l_debug_level) THEN
3960: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg75',' IGCCREPB -- Updating PO Headers ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3961: END IF;
3962: -- bug 3199488, end block
3963: UPDATE po_headers_all
3964: SET approved_flag = 'N'
3965: WHERE segment1 = l_cc_headers_rec.cc_num AND
3966: org_id = l_cc_headers_rec.org_id AND
3967: type_lookup_code = 'STANDARD' AND

Line 4050: FROM po_headers_all

4046:
4047: BEGIN
4048: SELECT count(po_header_id)
4049: INTO l_po_count
4050: FROM po_headers_all
4051: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
4052: org_id = l_rel_cc_headers_rec.org_id AND
4053: type_lookup_code = 'STANDARD' ;
4054: EXCEPTION

Line 4073: UPDATE po_headers_all

4069: END IF;
4070: -- bug 3199488, end block
4071:
4072: BEGIN
4073: UPDATE po_headers_all
4074: SET approved_flag = 'N'
4075: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
4076: org_id = l_rel_cc_headers_rec.org_id AND
4077: type_lookup_code = 'STANDARD' AND