APPS.PSP_POA_BUS dependencies on HR_ALL_ORGANIZATION_UNITS
Line 507: FROM pa_all_organizations p,hr_all_organization_units h
503: AND award_id = p_award_id;
504:
505: CURSOR exp_org_dates_csr IS
506: SELECT date_from, date_to 507: FROM pa_all_organizations p,hr_all_organization_units h 508: WHERE p.organization_id = h.organization_id
509: AND p.pa_org_use_type = 'EXPENDITURES'
510: AND h.organization_id = p_expenditure_organization_id
511: AND h.business_group_id = l_business_group_id