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.

[Home] [Help]

APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 799: FROM igs_pe_person_id_typ

795: FROM igs_pe_alt_pers_id
796: WHERE pe_person_id = p_person_id
797: AND person_id_type
798: IN (SELECT person_id_type
799: FROM igs_pe_person_id_typ
800: WHERE s_person_id_type = g_person_sevis_id)
801: AND start_dt <= trunc(sysdate)
802: AND NVL(end_dt,sysdate+1) >= trunc(sysdate);
803:

Line 1622: In all the 3 cursors replaced igs_pe_person_id_typ_v with igs_pe_person_id_typ

1618:
1619: Change History
1620: Who When What
1621: pkpatel 23-APR-2003 Bug 2908378
1622: In all the 3 cursors replaced igs_pe_person_id_typ_v with igs_pe_person_id_typ
1623: Added to find the active record.
1624: In c_get_drivers the region code is to be retrieved from region_cd instead of attribute11
1625: ------------------------------------------------------------------------
1626:

Line 1636: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS

1632: IS
1633:
1634: l_api_name CONSTANT VARCHAR(30) := 'Validate_Other_Info';
1635:
1636: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
1637: SELECT palt.api_person_id_uf,
1638: palt.region_cd
1639: FROM igs_pe_alt_pers_id palt,
1640: igs_pe_person_id_typ typv

Line 1640: igs_pe_person_id_typ typv

1636: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
1637: SELECT palt.api_person_id_uf,
1638: palt.region_cd
1639: FROM igs_pe_alt_pers_id palt,
1640: igs_pe_person_id_typ typv
1641: WHERE typv.s_person_id_type = cp_system_person_id_type
1642: AND palt.person_id_type = typv.person_id_type
1643: AND palt.pe_person_id = p_person_rec.person_id
1644: AND SYSDATE BETWEEN palt.start_dt AND NVL(palt.end_dt,SYSDATE);

Line 3673: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ

3669: SELECT alt.api_person_id
3670: FROM igs_pe_alt_pers_id alt
3671: WHERE
3672: alt.pe_person_id = c_dep_id AND
3673: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ
3674: WHERE s_person_id_type = 'SEVIS_ID') AND
3675: sysdate between alt.start_dt and nvl(alt.end_dt, sysdate+1);
3676: BEGIN
3677:

Line 10409: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ WHERE s_person_id_type = 'SEVIS_ID')

10405: p_dso_id IS NULL OR
10406: fr.person_id IN (SELECT rel.object_id FROM hz_relationships rel, igs_pe_alt_pers_id alt
10407: WHERE rel.subject_id = alt.pe_person_id and
10408: alt.api_person_id = p_dso_id and
10409: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ WHERE s_person_id_type = 'SEVIS_ID')
10410: AND rel.DIRECTIONAL_FLAG = 'F' AND sysdate between rel.start_date AND nvl(end_date, sysdate)
10411: AND rel.RELATIONSHIP_CODE = 'NEXT_OF_KIN_OF')
10412: )
10413: GROUP BY pr.party_number,fr.person_id, fr.no_show_flag, fr.reprint_reason;

Line 10436: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ

10432: fr.person_id IN (SELECT rel.object_id
10433: FROM hz_relationships rel, igs_pe_alt_pers_id alt
10434: WHERE rel.subject_id = alt.pe_person_id and
10435: alt.api_person_id = p_dso_id and
10436: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ
10437: WHERE s_person_id_type = 'SEVIS_ID') AND
10438: rel.DIRECTIONAL_FLAG = 'F' AND
10439: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
10440: rel.RELATIONSHIP_CODE = 'NEXT_OF_KIN_OF')

Line 10502: FROM igs_pe_person_id_typ

10498: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
10499: rel.RELATIONSHIP_CODE = 'NEXT_OF_KIN_FOR' AND
10500: alt.person_id_type
10501: IN (SELECT person_id_type
10502: FROM igs_pe_person_id_typ
10503: WHERE s_person_id_type = 'SEVIS_ID');
10504:
10505:
10506:

Line 11810: l_alt_id igs_pe_person_id_typ.person_id_type%TYPE;

11806: p_SEVIS_ErrorElement IN VARCHAR2
11807: )
11808: IS
11809: l_rowid VARCHAR2(255);
11810: l_alt_id igs_pe_person_id_typ.person_id_type%TYPE;
11811:
11812:
11813: CURSOR c_alt IS
11814: SELECT person_id_type

Line 11815: FROM igs_pe_person_id_typ

11811:
11812:
11813: CURSOR c_alt IS
11814: SELECT person_id_type
11815: FROM igs_pe_person_id_typ
11816: WHERE s_person_id_type = g_person_sevis_id AND
11817: closed_ind = 'N';
11818:
11819:

Line 11851: FROM igs_pe_person_id_typ

11847: SET end_dt = trunc(sysdate)
11848: WHERE pe_person_id = p_person_id
11849: AND person_id_type
11850: IN (SELECT person_id_type
11851: FROM igs_pe_person_id_typ
11852: WHERE s_person_id_type = g_person_sevis_id)
11853: AND start_dt <= trunc(sysdate)
11854: AND NVL(end_dt,sysdate+1) >= trunc(sysdate) ;
11855: