APPS.OTA_OM_UPD_API dependencies on HZ_CONTACT_POINTS

Line 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

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'

Line 1105: From HZ_CONTACT_POINTS con,

1101: Cursor get_fax IS
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')