DBA Data[Home] [Help]

APPS.IGS_PE_STAT_DETAILS_PKG dependencies on HZ_PARTIES

Line 22: -- added person_id mandatory FK with HZ_PARTIES. removed person_profile_id and all the obsoleted columns

18: -- Columns Added - MATR_CAL_TYPE/MATR_SEQUENCE_NUMBER/INIT_CAL_TYPE/INIT_SEQUENCE_NUMBER
19: -- RECENT_CAL_TYPE/RECENT_SEQUENCE_NUMBER/CATALOG_CAL_TYPE/CATALOG_SEQUENCE_NUMBER
20: -- Bayadav 31-Jan-2002 Bug number 2203778 .addded descriptive flexfield columns (IGS_PE_PERS_STAT )
21: -- ssawhney 2203778
22: -- added person_id mandatory FK with HZ_PARTIES. removed person_profile_id and all the obsoleted columns
23: ------------------------------------------------------------------
24:
25: l_rowid VARCHAR2(25);
26: old_references igs_pe_stat_details%ROWTYPE;

Line 249: FROM HZ_PARTIES

245:
246: PROCEDURE Check_Parent_Existance AS
247: CURSOR cur_rowid IS
248: SELECT ROWID
249: FROM HZ_PARTIES
250: WHERE PARTY_ID = new_references.PERSON_ID ;
251: lv_rowid cur_rowid%ROWTYPE;
252: /*
253: || Created By : bshankar