APPS.OTA_CPR_UTILITY dependencies on HZ_PARTIES

Line 438: HZ_PARTIES party,

434:
435: Cursor get_ext_lrn_party_id is
436: select party.party_id
437: from HZ_CUST_ACCOUNT_ROLES acct_role,
438: HZ_PARTIES party,
439: HZ_RELATIONSHIPS rel,
440: HZ_ORG_CONTACTS org_cont,
441: HZ_PARTIES rel_party,
442: HZ_CUST_ACCOUNTS role_acct

Line 441: HZ_PARTIES rel_party,

437: from HZ_CUST_ACCOUNT_ROLES acct_role,
438: HZ_PARTIES party,
439: HZ_RELATIONSHIPS rel,
440: HZ_ORG_CONTACTS org_cont,
441: HZ_PARTIES rel_party,
442: HZ_CUST_ACCOUNTS role_acct
443: where acct_role.party_id = rel.party_id
444: and acct_role.role_type = 'CONTACT'
445: and org_cont.party_relationship_id = rel.relationship_id

Line 448: and rel.subject_table_name = 'HZ_PARTIES'

444: and acct_role.role_type = 'CONTACT'
445: and org_cont.party_relationship_id = rel.relationship_id
446: and rel.subject_id = party.party_id
447: and rel.party_id = rel_party.party_id
448: and rel.subject_table_name = 'HZ_PARTIES'
449: and rel.object_table_name = 'HZ_PARTIES'
450: and acct_role.cust_account_id = role_acct.cust_account_id
451: and role_acct.party_id = rel.object_id
452: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 449: and rel.object_table_name = 'HZ_PARTIES'

445: and org_cont.party_relationship_id = rel.relationship_id
446: and rel.subject_id = party.party_id
447: and rel.party_id = rel_party.party_id
448: and rel.subject_table_name = 'HZ_PARTIES'
449: and rel.object_table_name = 'HZ_PARTIES'
450: and acct_role.cust_account_id = role_acct.cust_account_id
451: and role_acct.party_id = rel.object_id
452: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
453:

Line 454: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;

450: and acct_role.cust_account_id = role_acct.cust_account_id
451: and role_acct.party_id = rel.object_id
452: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
453:
454: l_ext_lrn_party_id HZ_PARTIES.Party_Id%TYPE;
455: l_user_id number;
456: l_user_type ota_attempts.user_type%type;
457: l_act_ver_id ota_activity_versions.activity_version_id%type;
458: l_prereq_completed_status varchar2(1);