APPS.IGS_AD_IMP_012 dependencies on HZ_PERSON_LANGUAGE

Line 1231: FROM hz_person_language pe, igs_ad_interface_all i

1227: match_ind = cst_mi_val_19
1228: WHERE ai.interface_run_id = l_interface_run_id
1229: AND ai.status = cst_stat_val_2
1230: AND EXISTS( SELECT '1'
1231: FROM hz_person_language pe, igs_ad_interface_all i
1232: WHERE i.interface_run_id = l_interface_run_id
1233: AND i.interface_id = ai.interface_id
1234: AND pe.party_id = i.person_id
1235: AND pe.language_name = UPPER(ai.language_name)

Line 1268: FROM hz_person_language pe, igs_ad_interface_all i

1264: WHERE mi.interface_run_id = l_interface_run_id
1265: AND mi.match_ind IS NULL
1266: AND mi.status = cst_stat_val_2
1267: AND EXISTS ( SELECT '1'
1268: FROM hz_person_language pe, igs_ad_interface_all i
1269: WHERE i.interface_run_id = l_interface_run_id
1270: AND i.interface_id = mi.interface_id
1271: AND pe.language_name = UPPER(mi.language_name)
1272: AND pe.party_id = i.person_id

Line 1292: FROM hz_person_language pe, igs_ad_interface_all i

1288: WHERE mi.interface_run_id = l_interface_run_id
1289: AND mi.match_ind IS NULL
1290: AND mi.status = cst_stat_val_2
1291: AND EXISTS (SELECT '1'
1292: FROM hz_person_language pe, igs_ad_interface_all i
1293: WHERE i.interface_run_id = l_interface_run_id
1294: AND i.interface_id = mi.interface_id
1295: AND pe.party_id = i.person_id
1296: AND pe.language_name = UPPER(mi.language_name));

Line 1303: FROM hz_person_language hi

1299: FOR person_language_rec IN person_language_cur(l_interface_run_id) LOOP
1300: DECLARE
1301: CURSOR check_dup_language(p_person_id NUMBER, p_language_name VARCHAR2 ) IS
1302: SELECT rowid, hi.*
1303: FROM hz_person_language hi
1304: WHERE hi.party_id = p_person_id
1305: AND hi.language_name = p_language_name;
1306: check_dup_language_rec check_dup_language%ROWTYPE;
1307: BEGIN

Line 1336: l_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;

1332: p_per_language_rec HZ_PERSON_INFO_V2PUB.person_language_rec_type;
1333:
1334: l_tmp_var1 VARCHAR2(500);
1335: l_tmp_var VARCHAR2(500);
1336: l_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;
1337:
1338:
1339: BEGIN
1340:

Line 1457: l_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;

1453: l_language_use_reference_id NUMBER;
1454: p_per_language_rec HZ_PERSON_INFO_V2PUB.person_language_rec_type;
1455: l_tmp_var1 VARCHAR2(500);
1456: l_tmp_var VARCHAR2(500);
1457: l_object_version_number hz_person_language.OBJECT_VERSION_NUMBER%TYPE;
1458:
1459:
1460: BEGIN
1461: