eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CPR_UTILITY dependencies on HZ_PARTIES

Line 444: HZ_PARTIES party,

440:
441: Cursor get_ext_lrn_party_id is
442: select party.party_id
443: from HZ_CUST_ACCOUNT_ROLES acct_role,
444: HZ_PARTIES party,
445: HZ_RELATIONSHIPS rel,
446: HZ_ORG_CONTACTS org_cont,
447: HZ_PARTIES rel_party,
448: HZ_CUST_ACCOUNTS role_acct

Line 447: HZ_PARTIES rel_party,

443: from HZ_CUST_ACCOUNT_ROLES acct_role,
444: HZ_PARTIES party,
445: HZ_RELATIONSHIPS rel,
446: HZ_ORG_CONTACTS org_cont,
447: HZ_PARTIES rel_party,
448: HZ_CUST_ACCOUNTS role_acct
449: where acct_role.party_id = rel.party_id
450: and acct_role.role_type = 'CONTACT'
451: and org_cont.party_relationship_id = rel.relationship_id

Line 454: and rel.subject_table_name = 'HZ_PARTIES'

450: and acct_role.role_type = 'CONTACT'
451: and org_cont.party_relationship_id = rel.relationship_id
452: and rel.subject_id = party.party_id
453: and rel.party_id = rel_party.party_id
454: and rel.subject_table_name = 'HZ_PARTIES'
455: and rel.object_table_name = 'HZ_PARTIES'
456: and acct_role.cust_account_id = role_acct.cust_account_id
457: and role_acct.party_id = rel.object_id
458: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 455: and rel.object_table_name = 'HZ_PARTIES'

451: and org_cont.party_relationship_id = rel.relationship_id
452: and rel.subject_id = party.party_id
453: and rel.party_id = rel_party.party_id
454: and rel.subject_table_name = 'HZ_PARTIES'
455: and rel.object_table_name = 'HZ_PARTIES'
456: and acct_role.cust_account_id = role_acct.cust_account_id
457: and role_acct.party_id = rel.object_id
458: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
459:

Line 460: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;

456: and acct_role.cust_account_id = role_acct.cust_account_id
457: and role_acct.party_id = rel.object_id
458: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
459:
460: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
461: l_user_id number;
462: l_user_type ota_attempts.user_type%type;
463: l_act_ver_id ota_activity_versions.activity_version_id%type;
464: l_prereq_completed_status varchar2(1);