APPS.IGS_AD_IMP_006 dependencies on IGS_PE_PERSON_BASE_V

Line 68: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

64: --------Start of local Validate_pe_alias ------
65: PROCEDURE Validate_pe_alias(PERSON_ALIAS_REC alias_cur%ROWTYPE,
66: l_error_code OUT NOCOPY VARCHAR2) AS
67: L_VAR VARCHAR2(1);
68: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
69: SELECT birth_date
70: FROM igs_pe_person_base_v
71: WHERE person_id= cp_person_id;
72:

Line 70: FROM igs_pe_person_base_v

66: l_error_code OUT NOCOPY VARCHAR2) AS
67: L_VAR VARCHAR2(1);
68: CURSOR birth_dt_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
69: SELECT birth_date
70: FROM igs_pe_person_base_v
71: WHERE person_id= cp_person_id;
72:
73: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
74:

Line 290: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

286: SELECT 'Y'
287: FROM igs_ps_dic_occ_titls
288: WHERE occupational_title_code = cp_occ_t_code;
289:
290: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
291: SELECT birth_date
292: FROM igs_pe_person_base_v
293: WHERE person_id = cp_person_id;
294:

Line 292: FROM igs_pe_person_base_v

288: WHERE occupational_title_code = cp_occ_t_code;
289:
290: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
291: SELECT birth_date
292: FROM igs_pe_person_base_v
293: WHERE person_id = cp_person_id;
294:
295: CURSOR employer_party_number_cur(cp_employer_party_number igs_ad_emp_int_all.employer_party_number%TYPE) IS
296: SELECT PARTY_ID

Line 304: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

300: status <> 'M';
301:
302:
303: l_var VARCHAR2(1);
304: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
305: l_employer_party_number VARCHAR2(1);
306:
307: BEGIN
308:

Line 977: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

973: -------------Start of local procedure validate_pe_excurr ------------
974: PROCEDURE validate_pe_excurr (EXTRACURR_REC IN extracurr%ROWTYPE, p_error_code OUT NOCOPY VARCHAR2) AS
975: l_var VARCHAR2(1);
976:
977: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
978: SELECT birth_date
979: FROM igs_pe_person_base_v
980: WHERE person_id = cp_person_id;
981:

Line 979: FROM igs_pe_person_base_v

975: l_var VARCHAR2(1);
976:
977: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
978: SELECT birth_date
979: FROM igs_pe_person_base_v
980: WHERE person_id = cp_person_id;
981:
982: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
983:

Line 982: l_birth_date igs_pe_person_base_v.birth_date%TYPE;

978: SELECT birth_date
979: FROM igs_pe_person_base_v
980: WHERE person_id = cp_person_id;
981:
982: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
983:
984: BEGIN
985:
986: --3. Perform validations for the following columns