APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 74: from hz_cust_account_roles acct_role,

70: l_more_than_one boolean;
71:
72: cursor c_customer_contact is
73: select distinct acct_role.cust_account_role_id contact_id
74: from hz_cust_account_roles acct_role,
75: hz_parties party,
76: hz_relationships rel,
77: hz_org_contacts org_cont,
78: hz_parties rel_party

Line 98: from hz_cust_account_roles acct_role,

94: ORDER BY 1;
95:
96: cursor c_address_contact is
97: select distinct acct_role.cust_account_role_id contact_id
98: from hz_cust_account_roles acct_role,
99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,

Line 792: from hz_cust_account_roles acct_role,

788: arp_util.debug('ar_deposit_lib_pvt.GET_CONTACT_ID() +' );
789: begin
790: SELECT acct_role.cust_account_role_id
791: INTO l_selected_id
792: from hz_cust_account_roles acct_role,
793: hz_parties party,
794: hz_relationships rel,
795: hz_org_contacts org_cont,
796: hz_parties rel_party

Line 2078: from hz_cust_account_roles acct_role,

2074: --validate contact id
2075: begin
2076: SELECT acct_role.cust_account_role_id
2077: INTO l_dummy
2078: from hz_cust_account_roles acct_role,
2079: hz_parties party,
2080: hz_relationships rel,
2081: hz_org_contacts org_cont,
2082: hz_parties rel_party

Line 2161: from hz_cust_account_roles acct_role,

2157: --validate x_ship_to_contact_id
2158: begin
2159: SELECT acct_role.cust_account_role_id
2160: INTO l_dummy
2161: from hz_cust_account_roles acct_role,
2162: hz_parties party,
2163: hz_relationships rel,
2164: hz_org_contacts org_cont,
2165: hz_parties rel_party