APPS.IGF_SL_GEN dependencies on IGS_PE_CONTACTS_V

Line 721: FUNCTION get_person_phone(p_person_id IGS_PE_CONTACTS_V.owner_table_id%TYPE)

717: END get_disb_date;
718:
719:
720: -- Function to get the phone number of the person
721: FUNCTION get_person_phone(p_person_id IGS_PE_CONTACTS_V.owner_table_id%TYPE)
722: RETURN VARCHAR2
723: AS
724: --
725: ------------------------------------------------------------------------

Line 750: FROM igs_pe_contacts_v

746: IS
747: SELECT
748: phone_area_code,
749: phone_number
750: FROM igs_pe_contacts_v
751: WHERE owner_table_id = p_person_id
752: AND primary_flag = 'Y'
753: AND status = 'A'
754: AND contact_point_type = 'PHONE';

Line 759: l_phone_area_code igs_pe_contacts_v.phone_area_code%TYPE;

755:
756: --
757: -- Declared variables to hold the phone details information */
758: --
759: l_phone_area_code igs_pe_contacts_v.phone_area_code%TYPE;
760: l_phone_number igs_pe_contacts_v.phone_number%TYPE;
761:
762:
763: BEGIN

Line 760: l_phone_number igs_pe_contacts_v.phone_number%TYPE;

756: --
757: -- Declared variables to hold the phone details information */
758: --
759: l_phone_area_code igs_pe_contacts_v.phone_area_code%TYPE;
760: l_phone_number igs_pe_contacts_v.phone_number%TYPE;
761:
762:
763: BEGIN
764:

Line 927: cp_primary_flag igs_pe_contacts_v.primary_flag%TYPE,

923:
924:
925: CURSOR c_get_emailaddr (
926: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
927: cp_primary_flag igs_pe_contacts_v.primary_flag%TYPE,
928: cp_status igs_pe_contacts_v.status%TYPE,
929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE
930: )
931: IS

Line 928: cp_status igs_pe_contacts_v.status%TYPE,

924:
925: CURSOR c_get_emailaddr (
926: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
927: cp_primary_flag igs_pe_contacts_v.primary_flag%TYPE,
928: cp_status igs_pe_contacts_v.status%TYPE,
929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE
930: )
931: IS
932: SELECT email_address

Line 929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE

925: CURSOR c_get_emailaddr (
926: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE,
927: cp_primary_flag igs_pe_contacts_v.primary_flag%TYPE,
928: cp_status igs_pe_contacts_v.status%TYPE,
929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE
930: )
931: IS
932: SELECT email_address
933: FROM igs_pe_contacts_v

Line 933: FROM igs_pe_contacts_v

929: cp_contact_point_type igs_pe_contacts_v.contact_point_type%TYPE
930: )
931: IS
932: SELECT email_address
933: FROM igs_pe_contacts_v
934: WHERE owner_table_id = cp_person_id
935: AND primary_flag = cp_primary_flag
936: AND status = cp_status
937: AND contact_point_type = cp_contact_point_type ;