APPS.IGS_AD_IMP_026 dependencies on IGS_PE_PERSON_BASE_V

Line 75: FROM igs_pe_person_base_v

71: p_mode IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
72:
73: CURSOR birth_dt_cur(cp_person_id igs_ad_interface.person_id%TYPE) IS
74: SELECT birth_date birth_dt
75: FROM igs_pe_person_base_v
76: WHERE person_id = cp_person_id;
77:
78: --kumma, 2941138, PKM_ISSUE, Used the bind variable instead of using the conact for preparing the statement
79: l_select_clause VARCHAR2(2000):=

Line 89: FROM igs_pe_person_base_v

85: l_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
86:
87: CURSOR party_id_cur IS
88: SELECT person_id
89: FROM igs_pe_person_base_v
90: WHERE person_id = visa_rec.AGENT_PERSON_ID ;
91:
92: CURSOR valid_pas_id IS
93: SELECT passport_number

Line 918: FROM IGS_PE_PERSON_BASE_V

914: FUNCTION Validate_Passport(pass_rec IN pass_dtls%ROWTYPE, p_err_code OUT NOCOPY VARCHAR2, p_mode IN VARCHAR2 DEFAULT NULL ) RETURN BOOLEAN IS
915:
916: CURSOR birth_dt_cur(cp_person_id igs_ad_interface.person_id%TYPE) IS
917: SELECT BIRTH_DATE Birth_dt
918: FROM IGS_PE_PERSON_BASE_V
919: WHERE person_id = cp_person_id;
920:
921: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
922:

Line 1562: FROM IGS_PE_PERSON_BASE_V

1558: RETURN BOOLEAN IS
1559:
1560: CURSOR birth_dt_cur(cp_person_id igs_ad_interface.person_id%TYPE) IS
1561: SELECT BIRTH_DATE Birth_dt
1562: FROM IGS_PE_PERSON_BASE_V
1563: WHERE
1564: person_id = cp_person_id;
1565:
1566:

Line 2359: FROM IGS_PE_PERSON_BASE_V

2355: RETURN BOOLEAN IS
2356:
2357: CURSOR birth_dt_cur(cp_person_id igs_ad_interface.person_id%TYPE) IS
2358: SELECT BIRTH_DATE Birth_dt
2359: FROM IGS_PE_PERSON_BASE_V
2360: WHERE
2361: person_id = cp_person_id;
2362:
2363: l_error VARCHAR2(30);