DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_ALL_ORGANIZATIONS

Line 2104: , pa_all_organizations org

2100: CURSOR get_max_asgmt_end_date IS
2101: select max(assignment_end_date)
2102: from pa_r_project_resources_ind_v res
2103: , hr_organization_information org_info
2104: , pa_all_organizations org
2105: where res.person_id = l_person_id
2106: and res.organization_id = org_info.organization_id
2107: and org_info.org_information_context = 'Exp Organization Defaults'
2108: and res.organization_id = org.organization_id

Line 2113: from pa_all_organizations org1

2109: and org.pa_org_use_type = 'EXPENDITURES'
2110: and org.inactive_date is null
2111: and (org.organization_id,org.org_id) = (
2112: select org1.organization_id, org1.org_id
2113: from pa_all_organizations org1
2114: where org1.pa_org_use_type = 'EXPENDITURES'
2115: and org1.inactive_date is null
2116: and org1.organization_id = org.organization_id
2117: and rownum = 1 );