APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on IGI_RA_ADDRESSES

Line 59: CURSOR C3 IS SELECT address_id FROM IGI_RA_ADDRESSES

55: CURSOR C1 IS SELECT party_site_id FROM HZ_PARTY_SITES
56: WHERE party_site_id = X_party_site_id;
57: CURSOR C2 IS SELECT rowid FROM HZ_CUST_ACCT_SITES
58: WHERE cust_acct_site_id = X_address_id;
59: CURSOR C3 IS SELECT address_id FROM IGI_RA_ADDRESSES
60: WHERE address_id = X_address_id;
61: CURSOR C4 IS SELECT location_id FROM HZ_LOC_ASSIGNMENTS
62: WHERE location_id = X_location_id;
63:

Line 253: INSERT INTO igi_ra_addresses(

249: x_msg_data); */
250:
251:
252:
253: INSERT INTO igi_ra_addresses(
254: address_id,
255: ORG_ID,
256: stp_common_ref,
257: stp_alt_addr,

Line 477: UPDATE igi_ra_addresses ira

473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data
475: );
476:
477: UPDATE igi_ra_addresses ira
478: SET
479: stp_common_ref = X_stp_common_ref,
480: stp_alt_addr = X_stp_alt_addr,
481: stp_supplier = X_stp_supplier,

Line 547: FROM igi_ra_addresses ira

543: RecAddr C%ROWTYPE;
544:
545: CURSOR C1 IS
546: SELECT *
547: FROM igi_ra_addresses ira
548: WHERE ira.address_id = (select CS.cust_acct_site_id
549: from HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES CS
550: WHERE PS.PARTY_SITE_ID = CS.PARTY_SITE_ID
551: AND LOC.LOCATION_ID = PS.LOCATION_ID