APPS.IGS_AD_IMP_006 dependencies on IGS_PS_DIC_OCC_TITLS

Line 285: CURSOR Validate_Occup_Title(cp_occ_t_code igs_ps_dic_occ_titls.occupational_title_code%TYPE) IS

281: PROCEDURE validate_emp_dtls (PERSON_EMP_REC IN emp_dtls%ROWTYPE,
282: P_EMPLOYER_PARTY_ID IN OUT NOCOPY NUMBER,
283: p_error_code OUT NOCOPY VARCHAR2) AS
284:
285: CURSOR Validate_Occup_Title(cp_occ_t_code igs_ps_dic_occ_titls.occupational_title_code%TYPE) IS
286: SELECT 'Y'
287: FROM igs_ps_dic_occ_titls
288: WHERE occupational_title_code = cp_occ_t_code;
289:

Line 287: FROM igs_ps_dic_occ_titls

283: p_error_code OUT NOCOPY VARCHAR2) AS
284:
285: CURSOR Validate_Occup_Title(cp_occ_t_code igs_ps_dic_occ_titls.occupational_title_code%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