APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_PE_PERSON

Line 843: FROM igs_pe_person_id_typ

839: FROM igs_pe_alt_pers_id
840: WHERE pe_person_id = p_person_id
841: AND person_id_type
842: IN (SELECT person_id_type
843: FROM igs_pe_person_id_typ
844: WHERE s_person_id_type = g_person_sevis_id)
845: AND start_dt <= trunc(sysdate)
846: AND NVL(end_dt,sysdate+1) >= trunc(sysdate);
847:

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

1843:
1844: Change History
1845: Who When What
1846: pkpatel 23-APR-2003 Bug 2908378
1847: In all the 3 cursors replaced igs_pe_person_id_typ_v with igs_pe_person_id_typ
1848: Added to find the active record.
1849: In c_get_drivers the region code is to be retrieved from region_cd instead of attribute11
1850: ------------------------------------------------------------------------
1851:

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

1857: IS
1858:
1859: l_api_name CONSTANT VARCHAR(30) := 'Validate_Other_Info';
1860:
1861: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
1862: SELECT palt.api_person_id_uf,
1863: palt.region_cd
1864: FROM igs_pe_alt_pers_id palt,
1865: igs_pe_person_id_typ typv

Line 1865: igs_pe_person_id_typ typv

1861: CURSOR c_alternate_id(cp_system_person_id_type igs_pe_person_id_typ.s_person_id_type%TYPE) IS
1862: SELECT palt.api_person_id_uf,
1863: palt.region_cd
1864: FROM igs_pe_alt_pers_id palt,
1865: igs_pe_person_id_typ typv
1866: WHERE typv.s_person_id_type = cp_system_person_id_type
1867: AND palt.person_id_type = typv.person_id_type
1868: AND palt.pe_person_id = p_person_rec.person_id
1869: AND SYSDATE BETWEEN palt.start_dt AND NVL(palt.end_dt,SYSDATE);

Line 4587: FROM igs_pe_person

4583: AND rel.status = 'A';
4584:
4585: CURSOR c_person_number(p_id NUMBER) IS
4586: SELECT person_number
4587: FROM igs_pe_person
4588: WHERE person_id = p_id;
4589:
4590: CURSOR c_spouse_of_rel IS
4591: SELECT COUNT(1)

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

4606: SELECT alt.api_person_id
4607: FROM igs_pe_alt_pers_id alt
4608: WHERE
4609: alt.pe_person_id = c_dep_id AND
4610: alt.person_id_type IN (SELECT person_id_type FROM igs_pe_person_id_typ
4611: WHERE s_person_id_type = 'SEVIS_ID') AND
4612: sysdate between alt.start_dt and nvl(alt.end_dt, sysdate+1);
4613: l_rel_type_count NUMBER := 0;
4614: BEGIN

Line 11651: FROM igs_pe_person_id_typ

11647: sysdate between rel.start_date AND nvl(end_date, sysdate) AND
11648: rel.RELATIONSHIP_CODE = 'HAS_DSO' AND
11649: alt.person_id_type
11650: IN (SELECT person_id_type
11651: FROM igs_pe_person_id_typ
11652: WHERE s_person_id_type = 'SEVIS_ID');
11653:
11654:
11655:

Line 12987: l_alt_id igs_pe_person_id_typ.person_id_type%TYPE;

12983: p_SEVIS_ErrorElement IN VARCHAR2
12984: )
12985: IS
12986: l_rowid VARCHAR2(255);
12987: l_alt_id igs_pe_person_id_typ.person_id_type%TYPE;
12988:
12989:
12990: CURSOR c_alt IS
12991: SELECT person_id_type

Line 12992: FROM igs_pe_person_id_typ

12988:
12989:
12990: CURSOR c_alt IS
12991: SELECT person_id_type
12992: FROM igs_pe_person_id_typ
12993: WHERE s_person_id_type = g_person_sevis_id AND
12994: closed_ind = 'N';
12995:
12996:

Line 13028: FROM igs_pe_person_id_typ

13024: SET end_dt = trunc(sysdate)
13025: WHERE pe_person_id = p_person_id
13026: AND person_id_type
13027: IN (SELECT person_id_type
13028: FROM igs_pe_person_id_typ
13029: WHERE s_person_id_type = g_person_sevis_id)
13030: AND start_dt <= trunc(sysdate)
13031: AND NVL(end_dt,sysdate+1) >= trunc(sysdate) ;
13032: