APPS.IGC_CC_MPFS_PROCESS_PKG dependencies on PO_HEADERS_ALL

Line 1818: FROM po_headers_all pha1,

1814: -- AND cchd.cc_num = pha2.segment1
1815: -- AND pha2.type_lookup_code = 'STANDARD');
1816: SELECT 'Y'
1817: INTO l_dummy
1818: FROM po_headers_all pha1,
1819: igc_cc_headers cchd
1820: WHERE cchd.org_id = p_org_id
1821: AND cchd.cc_header_id = l_cc_headers_rec.cc_header_id
1822: AND cchd.cc_num = pha1.segment1

Line 4069: FROM po_headers_all pha1, igc_cc_headers cchd

4065: -- AND cchd.cc_num = pha2.segment1
4066: -- AND pha2.type_lookup_code = 'STANDARD');
4067: SELECT 'Y'
4068: INTO l_dummy
4069: FROM po_headers_all pha1, igc_cc_headers cchd
4070: WHERE cchd.org_id = l_org_id
4071: AND cchd.cc_header_id = v4_1.cc_header_id
4072: AND cchd.cc_num = pha1.segment1
4073: AND pha1.type_lookup_code = 'STANDARD'

Line 4087: UPDATE po_headers_all pha1

4083: -- WHERE cchd.cc_header_id = V4.cc_header_id
4084: -- AND pha2.segment1 = cchd.cc_num
4085: -- AND pha2.org_id = cchd.org_id
4086: -- AND pha2.type_lookup_code = 'STANDARD');
4087: UPDATE po_headers_all pha1
4088: SET pha1.approved_flag = 'N'
4089: WHERE pha1.type_lookup_code = 'STANDARD'
4090: AND pha1.org_id = l_org_id
4091: AND pha1.segment1 =

Line 4312: FROM po_headers_all pha1, igc_cc_headers cchd

4308: -- AND cchd.cc_num = pha2.segment1
4309: -- AND pha2.type_lookup_code = 'STANDARD');
4310: SELECT 'Y'
4311: INTO l_dummy
4312: FROM po_headers_all pha1, igc_cc_headers cchd
4313: WHERE cchd.org_id = l_org_id
4314: AND cchd.cc_header_id = v5.cc_header_id
4315: AND cchd.cc_num = pha1.segment1
4316: AND pha1.type_lookup_code = 'STANDARD'

Line 4330: UPDATE po_headers_all pha1

4326: -- WHERE cchd.cc_header_id = V5.cc_header_id
4327: -- AND pha2.segment1 = cchd.cc_num
4328: -- AND pha2.org_id = cchd.org_id
4329: -- AND pha2.type_lookup_code = 'STANDARD');
4330: UPDATE po_headers_all pha1
4331: SET pha1.approved_flag = 'Y'
4332: WHERE pha1.type_lookup_code = 'STANDARD'
4333: AND pha1.org_id = l_org_id
4334: AND pha1.segment1 =