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_EMP_DTL_PKG dependencies on HZ_PERSON_PROFILES

Line 68: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES

64: l_msg_count NUMBER;
65: lrow_id varchar2(30);
66: tmp_var1 VARCHAR2(2000);
67: tmp_var VARCHAR2(2000);
68: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
69: WHERE party_id = x_person_id AND effective_end_Date is null;
70: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
71:
72: BEGIN

Line 70: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

66: tmp_var1 VARCHAR2(2000);
67: tmp_var VARCHAR2(2000);
68: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
69: WHERE party_id = x_person_id AND effective_end_Date is null;
70: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
71:
72: BEGIN
73: x_PROGRAM_UPDATE_DATE := SYSDATE;
74: x_PROGRAM_ID := 0;

Line 248: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES

244: SELECT rowid,hz_emp_dtl_id, occupational_title_code
245: FROM igs_ad_hz_emp_dtl
246: WHERE employment_history_id = x_employment_history_id;
247:
248: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
249: WHERE party_id = x_person_id AND effective_end_Date is null;
250: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
251:
252:

Line 250: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;

246: WHERE employment_history_id = x_employment_history_id;
247:
248: CURSOR c_birth_date_val is SELECT date_of_birth FROM HZ_PERSON_PROFILES
249: WHERE party_id = x_person_id AND effective_end_Date is null;
250: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
251:
252:
253: BEGIN
254: