APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGS_PE_ALT_PERS_ID

Line 1782: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

1778: WHEN others THEN
1779: RETURN NULL;
1780: END convert_to_number;
1781:
1782: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
1783: cp_original_ssn_txt VARCHAR2
1784: )
1785: AS
1786:

Line 1799: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (

1795:
1796: l_rowid ROWID;
1797:
1798: BEGIN
1799: IGS_PE_ALT_PERS_ID_PKG.INSERT_ROW (
1800: X_ROWID => l_rowid,
1801: X_PE_PERSON_ID => cp_person_id,
1802: X_API_PERSON_ID => cp_original_ssn_txt,
1803: X_PERSON_ID_TYPE => 'SSN',

Line 1864: FROM igs_pe_alt_pers_id

1860: */
1861: -- cursor to get the ssn no of a person
1862: CURSOR ssn_cur(cp_person_id number) IS
1863: SELECT api_person_id,api_person_id_uf, end_dt
1864: FROM igs_pe_alt_pers_id
1865: WHERE pe_person_id=cp_person_id
1866: AND person_id_type like 'SSN'
1867: AND SYSDATE < = NVL(end_dt,SYSDATE);
1868:

Line 5980: FROM igs_pe_alt_pers_id api,

5976: ) IS
5977:
5978: SELECT 'SSN' rec_type,
5979: api.pe_person_id person_id
5980: FROM igs_pe_alt_pers_id api,
5981: igs_pe_person_id_typ pit
5982: WHERE api.person_id_type = pit.person_id_type
5983: AND pit.s_person_id_type = 'SSN'
5984: AND SYSDATE between api.start_dt AND NVL(api.end_dt,SYSDATE)