APPS.IGS_OR_INST_IMP_003_PKG dependencies on HZ_PARTY_SITE_USES

Line 1581: FROM hz_party_site_uses

1577: --Cursor to fetch the existing address usage
1578: CURSOR cur_get_usage(cp_party_site_id hz_party_sites.party_site_id%TYPE,
1579: cp_addr_usage igs_or_adrusge_int.site_use_code%TYPE) IS
1580: SELECT site_use_type
1581: FROM hz_party_site_uses
1582: WHERE party_site_id = cp_party_site_id
1583: AND site_use_type = cp_addr_usage;
1584:
1585: --cursor added to validate country field in address interface table

Line 1680: igs_pe_party_site_use_pkg.hz_party_site_uses_ak(

1676: OPEN c_val_addr_usage(l_addr_usage,'PARTY_SITE_USE_CODE','Y');
1677: FETCH c_val_addr_usage INTO c_val_addr_usage_rec;
1678:
1679: IF c_val_addr_usage%FOUND THEN
1680: igs_pe_party_site_use_pkg.hz_party_site_uses_ak(
1681: p_action => 'INSERT',
1682: p_rowid => l_usage_row_id,
1683: p_party_site_use_id => l_party_site_use_id,
1684: p_party_site_id => l_party_site_id,