APPS.PA_TOP_TASK_CUST_INVOICE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 342: FROM pa_project_customers proj_cust, hz_cust_accounts HZ_C, HZ_PARTIES HZ_P

338: */
339:
340: CURSOR cur_get_ordered_customers IS
341: SELECT HZ_C.cust_account_id , HZ_P.party_name , HZ_P.party_number, 'Y'
342: FROM pa_project_customers proj_cust, hz_cust_accounts HZ_C, HZ_PARTIES HZ_P
343: WHERE proj_cust.project_id = p_project_id
344: AND proj_cust.customer_id = hz_c.cust_account_id
345: AND hz_c.party_id = hz_p.party_id
346: ORDER BY proj_cust.customer_bill_split desc, hz_p.party_name, HZ_P.party_number ;

Line 1123: FROM pa_project_customers ppc, hz_cust_accounts HZ_C, hz_parties HZ_P

1119: */
1120:
1121: CURSOR cur_get_top_task_customer IS
1122: SELECT ppc.customer_id, hz_p.party_name, hz_p.party_number
1123: FROM pa_project_customers ppc, hz_cust_accounts HZ_C, hz_parties HZ_P
1124: WHERE ppc.project_id = p_project_id
1125: AND ppc.default_top_task_cust_flag = 'Y'
1126: AND ppc.customer_id = hz_c.cust_account_id
1127: AND hz_c.party_id = hz_p.party_id;