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 2337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

2333: SUBSTRB( PARTY.PERSON_LAST_NAME,1,50) || ' ' ||
2334: SUBSTRB( PARTY.PERSON_FIRST_NAME,1,40) || ' ' ||
2335: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2336: FROM
2337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2338: HZ_PARTIES PARTY,
2339: HZ_RELATIONSHIPS REL,
2340: HZ_CUST_ACCOUNTS ROLE_ACCT
2341: WHERE

Line 2393: from HZ_CUST_ACCOUNT_ROLES acct_role,

2389: RETURN number IS
2390:
2391: CURSOR c_customer_id IS
2392: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2393: from HZ_CUST_ACCOUNT_ROLES acct_role,
2394: HZ_PARTIES party,
2395: HZ_RELATIONSHIPS rel,
2396: HZ_ORG_CONTACTS org_cont,
2397: HZ_PARTIES rel_party,

Line 2749: from HZ_CUST_ACCOUNT_ROLES acct_role,

2745: RETURN number IS
2746:
2747: Cursor get_ext_lrn_party_id is
2748: select party.party_id
2749: from HZ_CUST_ACCOUNT_ROLES acct_role,
2750: HZ_PARTIES party,
2751: HZ_RELATIONSHIPS rel,
2752: HZ_ORG_CONTACTS org_cont,
2753: HZ_PARTIES rel_party,

Line 3549: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

3545: paf.email_address is not null;
3546:
3547: cursor get_external_email_addresses is
3548: SELECT PARTY.EMAIL_ADDRESS
3549: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3550: HZ_PARTIES PARTY,
3551: HZ_RELATIONSHIPS REL,
3552: HZ_CUST_ACCOUNTS ROLE_ACCT,
3553: HZ_ROLE_RESPONSIBILITY ROL ,