APPS.PA_CANDIDATE_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1585: hz_cust_accounts cust_acct

1581: CURSOR project_customers IS
1582: SELECT ppc.customer_id, substrb(party.party_name,1,50) customer_name
1583: FROM pa_project_customers ppc,
1584: hz_parties party,
1585: hz_cust_accounts cust_acct
1586: WHERE ppc.project_id = p_project_id
1587: AND cust_acct.cust_account_id = ppc.customer_id
1588: and party.party_id = cust_acct.party_id;
1589:

Line 1838: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

1834: l_customer_id ra_customers.customer_id%TYPE;
1835: l_customer_name ra_customers.customer_name%TYPE;
1836: */
1837:
1838: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1839: l_customer_name hz_parties.party_name%TYPE;
1840: -- 4363092 end
1841:
1842: l_in_nf_recipients_rec PA_CLIENT_EXTN_CAND_WF.Users_List_Tbltyp;