eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_013 dependencies on HZ_PARTIES

Line 885: AND ( NOT EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

881: SELECT cst_insert dmlmode, rowid, a.*
882: FROM IGS_AD_ACADHIS_INT_ALL a
883: WHERE a.interface_run_id = p_interface_run_id
884: AND a.status = '2'
885: AND ( NOT EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
886: WHERE h1.party_id = a.person_id
887: AND h2.party_number = a.institution_code
888: AND h2.party_id = h1.school_party_id )
889: OR ( p_rule = 'R' AND a.match_ind IN ('16', '25') )

Line 901: AND ( EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

897: FROM IGS_AD_ACADHIS_INT_ALL a
898: WHERE a.interface_run_id = p_interface_run_id
899: AND a.status = '2'
900: AND ( p_rule = 'I' OR (p_rule = 'R' AND a.match_ind = cst_mi_val_21))
901: AND ( EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
902: WHERE h1.party_id = a.person_id
903: AND h2.party_number = a.institution_code
904: AND h2.party_id = h1.school_party_id
905: AND TRUNC(NVL(h1.start_date_attended,

Line 927: AND EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

923: WHERE a.interface_run_id = p_interface_run_id
924: AND a.status = '2'
925: AND UPDATE_EDUCATION_ID IS NULL
926: AND NVL(a.start_date,a.end_date) IS NOT NULL
927: AND EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
928: WHERE h1.party_id = a.person_id
929: AND h2.party_id = h1.school_party_id
930: AND h2.party_number = a.institution_code
931: AND h1.start_date_attended IS NULL

Line 934: AND NOT EXISTS ( SELECT 1 FROM hz_Education h1, hz_parties h2

930: AND h2.party_number = a.institution_code
931: AND h1.start_date_attended IS NULL
932: AND h1.last_date_attended IS NULL
933: )
934: AND NOT EXISTS ( SELECT 1 FROM hz_Education h1, hz_parties h2
935: WHERE h1.party_id = a.person_id
936: AND h2.party_number = a.institution_code
937: AND h2.party_id = h1.school_party_id
938: AND NVL(h1.start_date_attended,

Line 950: AND 1 = (SELECT count(*) FROM hz_Education h1, hz_parties h2

946: WHERE a.interface_run_id = p_interface_run_id
947: AND a.status = '2'
948: AND UPDATE_EDUCATION_ID IS NULL
949: AND (p_rule = 'I' OR (p_rule = 'R' AND a.match_ind = cst_mi_val_21))
950: AND 1 = (SELECT count(*) FROM hz_Education h1, hz_parties h2
951: WHERE h1.party_id = a.person_id
952: AND h2.party_id = h1.school_party_id
953: AND h2.party_number = a.institution_code
954: AND NVL(h1.start_date_attended,h1.last_date_attended) IS NOT NULL

Line 964: AND NOT EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

960: TO_DATE('01-01-0001','DD-MM-YYYY'))) <>
961: TRUNC(NVL(a.end_date,
962: TO_DATE('01-01-0001','DD-MM-YYYY'))))
963: )
964: AND NOT EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
965: WHERE h1.party_id = a.person_id
966: AND h2.party_number = a.institution_code
967: AND h2.party_id = h1.school_party_id
968: AND TRUNC(NVL(h1.start_date_attended,

Line 1007: (SELECT MIN(he.creation_date) FROM hz_education he, hz_parties hz

1003: FROM igs_ad_acad_history_v ah
1004: WHERE person_id = acad_hist_rec.person_id
1005: AND institution_code = acad_hist_rec.institution_code
1006: AND CREATION_DATE =
1007: (SELECT MIN(he.creation_date) FROM hz_education he, hz_parties hz
1008: WHERE he.party_id = acad_hist_rec.person_id
1009: AND hz.party_id = he.school_party_id
1010: AND hz.party_number = acad_hist_rec.institution_code );
1011:

Line 1040: hz_parties p,

1036:
1037: CURSOR c_val_inst_cd_non_uk_cur IS
1038: SELECT hp.rowid row_id
1039: FROM
1040: hz_parties p,
1041: igs_pe_hz_parties hp
1042: WHERE hp.party_id = p.party_id
1043: AND hp.inst_org_ind = 'I'
1044: AND p.party_number = person_history_rec.institution_code;

Line 1041: igs_pe_hz_parties hp

1037: CURSOR c_val_inst_cd_non_uk_cur IS
1038: SELECT hp.rowid row_id
1039: FROM
1040: hz_parties p,
1041: igs_pe_hz_parties hp
1042: WHERE hp.party_id = p.party_id
1043: AND hp.inst_org_ind = 'I'
1044: AND p.party_number = person_history_rec.institution_code;
1045:

Line 1048: FROM HZ_PARTIES P,

1044: AND p.party_number = person_history_rec.institution_code;
1045:
1046: CURSOR c_val_inst_cd_uk_cur IS
1047: SELECT HP.rowid row_id
1048: FROM HZ_PARTIES P,
1049: IGS_PE_HZ_PARTIES HP,
1050: IGS_OR_ORG_INST_TYPE_ALL OIT
1051: WHERE HP.PARTY_ID = P.PARTY_ID
1052: AND HP.INST_ORG_IND = 'I'

Line 1049: IGS_PE_HZ_PARTIES HP,

1045:
1046: CURSOR c_val_inst_cd_uk_cur IS
1047: SELECT HP.rowid row_id
1048: FROM HZ_PARTIES P,
1049: IGS_PE_HZ_PARTIES HP,
1050: IGS_OR_ORG_INST_TYPE_ALL OIT
1051: WHERE HP.PARTY_ID = P.PARTY_ID
1052: AND HP.INST_ORG_IND = 'I'
1053: AND p.party_number = person_history_rec.institution_code

Line 1663: FROM hz_Education h1, hz_parties h2

1659: WHERE interface_run_id = p_interface_run_id
1660: AND status = '2'
1661: AND UPDATE_EDUCATION_ID IS NULL
1662: AND 1 < ( SELECT COUNT (*)
1663: FROM hz_Education h1, hz_parties h2
1664: WHERE h1.party_id = a.person_id
1665: AND h2.party_number = a.institution_code
1666: AND h2.party_id = h1.school_party_id
1667: AND TRUNC(NVL(h1.start_date_attended,

Line 1691: FROM hz_Education h1, hz_parties h2

1687: AND status = '2'
1688: AND UPDATE_EDUCATION_ID IS NULL
1689: AND NVL(match_ind, '15') IN ('15', '21')
1690: AND 1 < ( SELECT COUNT (*)
1691: FROM hz_Education h1, hz_parties h2
1692: WHERE h1.party_id = a.person_id
1693: AND h2.party_number = a.institution_code
1694: AND h2.party_id = h1.school_party_id
1695: AND TRUNC(NVL(h1.start_date_attended,

Line 1725: AND 1 < (SELECT count(*) FROM hz_Education h1, hz_parties h2

1721: ,error_code = 'E708'
1722: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
1723: WHERE interface_run_id = p_interface_run_id
1724: AND status = '2'
1725: AND 1 < (SELECT count(*) FROM hz_Education h1, hz_parties h2
1726: WHERE h1.party_id = a.person_id
1727: AND h2.party_number = a.institution_code
1728: AND h2.party_id = h1.school_party_id
1729: AND TRUNC(NVL(h1.start_date_attended,

Line 1748: ( SELECT h1.education_id FROM hz_Education h1, hz_parties h2

1744: SET
1745: status = '1'
1746: , match_ind = '19'
1747: , education_id =
1748: ( SELECT h1.education_id FROM hz_Education h1, hz_parties h2
1749: WHERE h1.party_id = a.person_id
1750: AND h2.party_number = a.institution_code
1751: AND h2.party_id = h1.school_party_id
1752: AND TRUNC(NVL(h1.start_date_attended,

Line 1763: AND EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

1759: TO_DATE('01-01-0001','DD-MM-YYYY')))
1760: AND rownum <= 1 )
1761: WHERE interface_run_id = p_interface_run_id
1762: AND status = '2'
1763: AND EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
1764: WHERE h1.party_id = a.person_id
1765: AND h2.party_number = a.institution_code
1766: AND h2.party_id = h1.school_party_id
1767: AND TRUNC(NVL(h1.start_date_attended,

Line 1783: ( SELECT h1.education_id FROM hz_Education h1, hz_parties h2

1779: SET
1780: status = '1'
1781: , match_ind = '19'
1782: , education_id =
1783: ( SELECT h1.education_id FROM hz_Education h1, hz_parties h2
1784: WHERE h1.party_id = a.person_id
1785: AND h2.party_number = a.institution_code
1786: AND h2.party_id = h1.school_party_id
1787: AND NVL(h1.start_date_attended,h1.last_date_attended) IS NOT NULL

Line 1799: AND 1 = (SELECT count(*) FROM hz_Education h1, hz_parties h2

1795: TO_DATE('01-01-0001','DD-MM-YYYY'))))
1796: )
1797: WHERE interface_run_id = p_interface_run_id
1798: AND status = '2'
1799: AND 1 = (SELECT count(*) FROM hz_Education h1, hz_parties h2
1800: WHERE h1.party_id = a.person_id
1801: AND h2.party_number = a.institution_code
1802: AND h2.party_id = h1.school_party_id
1803: AND NVL(h1.start_date_attended,h1.last_date_attended) IS NOT NULL

Line 1967: (SELECT education_id FROM hz_Education h1, hz_parties h2

1963: status = '3'
1964: , match_ind = '20'
1965: , dup_acad_history_id = ( SELECT hz_acad_hist_id FROM igs_Ad_Hz_Acad_Hist
1966: WHERE education_id =
1967: (SELECT education_id FROM hz_Education h1, hz_parties h2
1968: WHERE h1.party_id = acad.person_id
1969: AND h2.party_number = acad.institution_code
1970: AND h2.party_id = h1.school_party_id
1971: AND NVL(h1.start_date_attended,

Line 1987: AND ( EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2

1983:
1984: WHERE interface_run_id = p_interface_run_id
1985: AND status = '2'
1986: AND NVL (match_ind, '15') = '15'
1987: AND ( EXISTS (SELECT 1 FROM hz_Education h1, hz_parties h2
1988: WHERE h1.party_id = acad.person_id
1989: AND h2.party_number = acad.institution_code
1990: AND h2.party_id = h1.school_party_id
1991: AND NVL(h1.start_date_attended,

Line 2011: AND 1< ( SELECT COUNT(*) FROM hz_Education h1, hz_parties h2

2007: status = '3'
2008: , match_ind = '14'
2009: WHERE interface_run_id = p_interface_run_id
2010: AND status = '2'
2011: AND 1< ( SELECT COUNT(*) FROM hz_Education h1, hz_parties h2
2012: WHERE h1.party_id = acad.person_id
2013: AND h2.party_number = acad.institution_code
2014: AND h2.party_id = h1.school_party_id
2015: );

Line 2025: AND EXISTS ( SELECT 1 FROM hz_Education h1, hz_parties h2

2021: status = '3'
2022: , match_ind = '20'
2023: WHERE interface_run_id = p_interface_run_id
2024: AND status = '2'
2025: AND EXISTS ( SELECT 1 FROM hz_Education h1, hz_parties h2
2026: WHERE h1.party_id = acad.person_id
2027: AND h2.party_number = acad.institution_code
2028: AND h2.party_id = h1.school_party_id
2029: );

Line 2164: hz_parties

2160: CURSOR c_reviewer_id (cp_pe_cr_rec c_pe_cr_cur%ROWTYPE) IS
2161: SELECT
2162: 'X'
2163: FROM
2164: hz_parties
2165: WHERE
2166: party_id = cp_pe_cr_rec.reviewer_id;
2167:
2168: credential_type_id_rec c_credential_type_id%ROWTYPE;