[Home] [Help]
188: cursor contact(
189: p_party_id hz_parties.party_id%type) is
190: select acct_role.cust_account_role_id
191: from hz_cust_account_roles acct_role,
192: hz_relationships rel,
193: hz_cust_accounts role_acct
194: where acct_role.party_id = rel.party_id and
195: acct_role.role_type = 'CONTACT' and
196: acct_role.cust_account_id = role_acct.cust_account_id and
541: from ota_events ev,
542: ota_delegate_bookings book,
543: ota_booking_status_types stype,
544: hz_cust_account_roles acct_role,
545: hz_relationships rel,
546: hz_cust_accounts role_acct
547: where nvl(ev.course_start_date, sysdate) <= sysdate and
548: book.event_id = ev.event_id and
549: book.booking_status_type_id = stype.booking_status_type_id and
705: ota_learning_objects lo,
706: ota_delegate_bookings book,
707: ota_booking_status_types stype,
708: hz_cust_account_roles acct_role,
709: hz_relationships rel,
710: hz_cust_accounts role_acct,
711: ota_activity_versions act
712: where lo.source_learning_object_id = p_lo_id and
713: lo.learning_object_id = offr.learning_object_id and
1677: cursor get_delegate_contact(
1678: p_party_id hz_parties.party_id%type) is
1679: select acct_role.cust_account_role_id
1680: from hz_cust_account_roles acct_role,
1681: hz_relationships rel,
1682: hz_cust_accounts role_acct
1683: where acct_role.party_id = rel.party_id and
1684: acct_role.role_type = 'CONTACT' and
1685: acct_role.cust_account_id = role_acct.cust_account_id and