APPS.PA_PROJECT_REQUEST_PVT dependencies on HZ_CUST_ACCOUNTS

Line 568: --hz_cust_accounts a,--bug#9132476

564: FROM
565: pa_project_requests r,
566: hz_parties p,
567: hz_party_sites s,
568: --hz_cust_accounts a,--bug#9132476
569: hz_locations lc,
570: fnd_territories_vl ft
571: WHERE r.cust_party_id = p.party_id(+)
572: AND r.cust_party_site_id = s.party_site_id(+)

Line 1087: FROM hz_cust_accounts

1083: cur_sel_opportunities_rec cur_sel_opportunities_rec_type;
1084:
1085: CURSOR cur_sel_account_id (p_party_id NUMBER ) IS
1086: SELECT cust_account_id
1087: FROM hz_cust_accounts
1088: WHERE party_id = p_party_id;
1089:
1090: CURSOR cur_report_info (p_request_id NUMBER ) IS
1091: SELECT

Line 1452: FROM hz_cust_accounts

1448: Debug('l_account_id: ' || l_account_id);
1449:
1450: SELECT count(*)
1451: INTO l_number_of_accounts
1452: FROM hz_cust_accounts
1453: WHERE party_id = l_cust_party_id;
1454:
1455: Debug('After select count(*)');
1456: