[Home] [Help]
1088: and business_group_id = L_BUSINESS_GROUP_ID;
1089: --
1090: -- Bug 2599144 Country code added and a space added in between numbers ---
1091: Cursor get_phone IS
1092: select con.phone_country_code||' '|| con.phone_area_code||' '||decode(con.contact_point_type,'TLX',con.telex_number,con.phone_number) from hz_contact_points con, hz_cust_account_roles acct_role
1093: where con.owner_table_id=acct_role.party_id
1094: and con.Primary_Flag='Y'
1095: and acct_role.cust_account_role_id=l_stud_cont
1096: And con.owner_table_name = 'HZ_PARTIES'
1102: Select phone_country_code||' '||phone_area_code ||' '||
1103: decode(con.contact_point_type,'TLX',con.telex_number,con.phone_number)
1104: phone_number
1105: From HZ_CONTACT_POINTS con,
1106: HZ_CUST_ACCOUNT_ROLES car
1107: where car.party_id = con.owner_table_id
1108: and con.owner_table_name = 'HZ_PARTIES'
1109: and con.contact_point_type not in ('EDI','EMAIL','WEB')
1110: and car.cust_account_role_id = l_stud_cont
1111: and nvl(con.phone_line_type,con.contact_point_type) = 'FAX';
1112: --
1113: Cursor get_email IS
1114: Select rel_party.email_address
1115: From HZ_CUST_ACCOUNT_ROLES acct_role,
1116: HZ_PARTIES rel_party,
1117: HZ_RELATIONSHIPS rel,
1118: HZ_CUST_ACCOUNTS role_acct
1119: where acct_role.party_id = rel.party_id