APPS.PA_CANDIDATE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1839: hz_cust_accounts cust_acct

1835: CURSOR project_customers IS
1836: SELECT ppc.customer_id, substrb(party.party_name,1,50) customer_name
1837: FROM pa_project_customers ppc,
1838: hz_parties party,
1839: hz_cust_accounts cust_acct
1840: WHERE ppc.project_id = p_project_id
1841: AND cust_acct.cust_account_id = ppc.customer_id
1842: and party.party_id = cust_acct.party_id;
1843:

Line 2092: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

2088: l_customer_id ra_customers.customer_id%TYPE;
2089: l_customer_name ra_customers.customer_name%TYPE;
2090: */
2091:
2092: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
2093: l_customer_name hz_parties.party_name%TYPE;
2094: -- 4363092 end
2095:
2096: l_in_nf_recipients_rec PA_CLIENT_EXTN_CAND_WF.Users_List_Tbltyp;