[Home] [Help]
124: p_party_id hz_parties.party_id%type) is
125: select acct_role.cust_account_role_id
126: from hz_cust_account_roles acct_role,
127: hz_relationships rel,
128: hz_cust_accounts role_acct
129: where acct_role.party_id = rel.party_id and
130: acct_role.role_type = 'CONTACT' and
131: acct_role.cust_account_id = role_acct.cust_account_id and
132: role_acct.party_id = rel.object_id and
253: ota_delegate_bookings book,
254: ota_booking_status_types stype,
255: hz_cust_account_roles acct_role,
256: hz_relationships rel,
257: hz_cust_accounts role_acct
258: where nvl(ev.course_start_date, sysdate) <= sysdate and
259: book.event_id = ev.event_id and
260: book.booking_status_type_id = stype.booking_status_type_id and
261: ev.event_id = p_event_id and
404: ota_delegate_bookings book,
405: ota_booking_status_types stype,
406: hz_cust_account_roles acct_role,
407: hz_relationships rel,
408: hz_cust_accounts role_acct
409: where lo.source_learning_object_id = p_lo_id and
410: lo.learning_object_id = offr.learning_object_id and
411: offr.offering_id = ev.parent_offering_id and
412: nvl(ev.course_start_date, sysdate) <= sysdate and