APPS.INV_LABEL_PVT8 dependencies on HZ_CUST_ACCOUNTS

Line 1071: , hz_cust_accounts cust_acct

1067: CURSOR c_customer(p_customer_id NUMBER) IS
1068: SELECT substrb(party.party_name,1,50) customer_name,
1069: cust_acct.account_number customer_number
1070: FROM hz_parties party
1071: , hz_cust_accounts cust_acct
1072: WHERE cust_acct.party_id = party.party_id
1073: AND cust_acct.cust_account_id = p_customer_id;
1074:
1075: CURSOR c_project(p_project_id NUMBER) IS

Line 1189: hz_cust_accounts ROLE_ACCT

1185: SUBSTRB(PARTY.person_first_name,1,40) first_name
1186: FROM hz_cust_account_roles ACCT_ROLE,
1187: hz_parties PARTY,
1188: hz_relationships REL,
1189: hz_cust_accounts ROLE_ACCT
1190: WHERE
1191: ACCT_ROLE.party_id = REL.party_id
1192: AND ACCT_ROLE.role_type = 'CONTACT'
1193: AND REL.subject_id = PARTY.party_id