APPS.INV_LABEL_PVT8 dependencies on HZ_CUST_ACCOUNTS

Line 973: , hz_cust_accounts cust_acct

969: CURSOR c_customer(p_customer_id NUMBER) IS
970: SELECT substrb(party.party_name,1,50) customer_name,
971: cust_acct.account_number customer_number
972: FROM hz_parties party
973: , hz_cust_accounts cust_acct
974: WHERE cust_acct.party_id = party.party_id
975: AND cust_acct.cust_account_id = p_customer_id;
976:
977: CURSOR c_project(p_project_id NUMBER) IS

Line 1091: hz_cust_accounts ROLE_ACCT

1087: SUBSTRB(PARTY.person_first_name,1,40) first_name
1088: FROM hz_cust_account_roles ACCT_ROLE,
1089: hz_parties PARTY,
1090: hz_relationships REL,
1091: hz_cust_accounts ROLE_ACCT
1092: WHERE
1093: ACCT_ROLE.party_id = REL.party_id
1094: AND ACCT_ROLE.role_type = 'CONTACT'
1095: AND REL.subject_id = PARTY.party_id