APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on PO_HEADERS_ALL

Line 2762: FROM po_headers_all

2758:
2759: BEGIN
2760: SELECT count(po_header_id)
2761: INTO l_po_count
2762: FROM po_headers_all
2763: WHERE segment1 = l_cc_headers_rec.cc_num AND
2764: org_id = l_cc_headers_rec.org_id AND
2765: type_lookup_code = 'STANDARD' ;
2766: EXCEPTION

Line 2776: UPDATE po_headers_all

2772: IF (l_po_count = 1)
2773: THEN
2774:
2775: BEGIN
2776: UPDATE po_headers_all
2777: SET approved_flag = 'N'
2778: WHERE segment1 = l_cc_headers_rec.cc_num AND
2779: org_id = l_cc_headers_rec.org_id AND
2780: type_lookup_code = 'STANDARD' AND

Line 2813: FROM po_headers_all

2809:
2810: BEGIN
2811: SELECT count(po_header_id)
2812: INTO l_po_count
2813: FROM po_headers_all
2814: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
2815: org_id = l_rel_cc_headers_rec.org_id AND
2816: type_lookup_code = 'STANDARD' ;
2817: EXCEPTION

Line 2827: UPDATE po_headers_all

2823: IF (l_po_count = 1)
2824: THEN
2825:
2826: BEGIN
2827: UPDATE po_headers_all
2828: SET approved_flag = 'N'
2829: WHERE segment1 = l_rel_cc_headers_rec.cc_num AND
2830: org_id = l_rel_cc_headers_rec.org_id AND
2831: type_lookup_code = 'STANDARD' AND