APPS.OTA_UTILITY dependencies on HZ_CUST_ACCOUNT_ROLES

Line 336: l_contact_id hz_cust_account_roles.cust_account_role_id%type;

332: l_event_title ota_events_tl.title%type; --MLS Change added _tl
333: l_start_date date;
334: l_end_date date;
335: l_full_name ota_customer_contacts_v.full_name%type;
336: l_contact_id hz_cust_account_roles.cust_account_role_id%type;
337: l_version_name ota_activity_versions_tl.version_name%type; --MLS Change added _tl
338:
339:
340: l_max_attendee number(3);

Line 2273: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2269: SUBSTRB( PARTY.PERSON_LAST_NAME,1,50) || ' ' ||
2270: SUBSTRB( PARTY.PERSON_FIRST_NAME,1,40) || ' ' ||
2271: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2272: FROM
2273: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2274: HZ_PARTIES PARTY,
2275: HZ_RELATIONSHIPS REL,
2276: HZ_CUST_ACCOUNTS ROLE_ACCT
2277: WHERE

Line 2329: from HZ_CUST_ACCOUNT_ROLES acct_role,

2325: RETURN number IS
2326:
2327: CURSOR c_customer_id IS
2328: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2329: from HZ_CUST_ACCOUNT_ROLES acct_role,
2330: HZ_PARTIES party,
2331: HZ_RELATIONSHIPS rel,
2332: HZ_ORG_CONTACTS org_cont,
2333: HZ_PARTIES rel_party,

Line 2685: from HZ_CUST_ACCOUNT_ROLES acct_role,

2681: RETURN number IS
2682:
2683: Cursor get_ext_lrn_party_id is
2684: select party.party_id
2685: from HZ_CUST_ACCOUNT_ROLES acct_role,
2686: HZ_PARTIES party,
2687: HZ_RELATIONSHIPS rel,
2688: HZ_ORG_CONTACTS org_cont,
2689: HZ_PARTIES rel_party,