[Home] [Help]
APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PN_SPACE_ASSIGN_CUST_ALL
Line 741: pn_space_assign_cust_all cust
737: ar_lookups arl,
738: hz_cust_accounts hca,
739: pa_projects_all pa,
740: pa_tasks pat,
741: pn_space_assign_cust_all cust
742: WHERE cust.location_id = v_location_id_2
743: AND hca.cust_account_id = cust.cust_account_id
744: AND hca.party_id = hp.party_id
745: AND arl.lookup_code(+) = hp.category_code