APPS.IGS_FI_GEN_006 dependencies on IGS_PE_PERSON_ID_TYP

Line 633: CURSOR cur_usr_alt_prs_id_typ(cp_c_usr_alt_prs_id_typ igs_pe_person_id_typ.person_id_type%TYPE,

629: || Who When What
630: || gmaheswa 29-Sep-2004 BUG 3787210 Added Closed indicator check for the Alternate Person Id type.
631: ----------------------------------------------------------------------------*/
632:
633: CURSOR cur_usr_alt_prs_id_typ(cp_c_usr_alt_prs_id_typ igs_pe_person_id_typ.person_id_type%TYPE,
634: cp_c_unique igs_pe_person_id_typ.unique_ind%TYPE)
635: IS
636: SELECT s_person_id_type
637: FROM igs_pe_person_id_typ

Line 634: cp_c_unique igs_pe_person_id_typ.unique_ind%TYPE)

630: || gmaheswa 29-Sep-2004 BUG 3787210 Added Closed indicator check for the Alternate Person Id type.
631: ----------------------------------------------------------------------------*/
632:
633: CURSOR cur_usr_alt_prs_id_typ(cp_c_usr_alt_prs_id_typ igs_pe_person_id_typ.person_id_type%TYPE,
634: cp_c_unique igs_pe_person_id_typ.unique_ind%TYPE)
635: IS
636: SELECT s_person_id_type
637: FROM igs_pe_person_id_typ
638: WHERE person_id_type = cp_c_usr_alt_prs_id_typ AND

Line 637: FROM igs_pe_person_id_typ

633: CURSOR cur_usr_alt_prs_id_typ(cp_c_usr_alt_prs_id_typ igs_pe_person_id_typ.person_id_type%TYPE,
634: cp_c_unique igs_pe_person_id_typ.unique_ind%TYPE)
635: IS
636: SELECT s_person_id_type
637: FROM igs_pe_person_id_typ
638: WHERE person_id_type = cp_c_usr_alt_prs_id_typ AND
639: NVL(unique_ind,'N') = cp_c_unique AND
640: closed_ind = 'N';
641: l_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;

Line 641: l_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;

637: FROM igs_pe_person_id_typ
638: WHERE person_id_type = cp_c_usr_alt_prs_id_typ AND
639: NVL(unique_ind,'N') = cp_c_unique AND
640: closed_ind = 'N';
641: l_c_sys_prsn_id_typ igs_pe_person_id_typ.s_person_id_type%TYPE;
642:
643: BEGIN
644:
645: -- Check if the mandatory parameters are passed to this procedure