DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_BUDGET_VERSIONS

Line 2139: ,PA_BUDGET_VERSIONS bv

2135: FROM
2136: (
2137: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2138: FROM PA_RESOURCE_ASSIGNMENTS ra
2139: ,PA_BUDGET_VERSIONS bv
2140: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2141: WHERE ra.project_id = bv.project_id
2142: AND bv.project_id = evs.project_id
2143: AND ra.budget_version_id = bv.budget_version_id

Line 2151: ,PA_BUDGET_VERSIONS bv

2147: AND evs.status_code = 'STRUCTURE_WORKING')
2148: UNION ALL
2149: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id
2150: FROM PA_RESOURCE_ASSIGNMENTS ra
2151: ,PA_BUDGET_VERSIONS bv
2152: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2153: ,PA_PROJ_WORKPLAN_ATTR pwa
2154: WHERE pwa.wp_enable_Version_flag = 'N'
2155: AND pwa.project_id = ra.project_id

Line 2172: ,PA_BUDGET_VERSIONS bv

2168: FROM
2169: (
2170: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2171: FROM PA_RESOURCE_ASSIGNMENTS ra
2172: ,PA_BUDGET_VERSIONS bv
2173: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2174: WHERE ra.project_id = bv.project_id
2175: AND bv.project_id = evs.project_id
2176: AND ra.budget_version_id = bv.budget_version_id

Line 2184: ,PA_BUDGET_VERSIONS bv

2180: AND evs.status_code = 'STRUCTURE_WORKING')
2181: UNION ALL
2182: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2183: FROM PA_RESOURCE_ASSIGNMENTS ra
2184: ,PA_BUDGET_VERSIONS bv
2185: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2186: ,PA_PROJ_WORKPLAN_ATTR pwa
2187: WHERE pwa.wp_enable_Version_flag = 'N'
2188: AND pwa.project_id = ra.project_id

Line 2214: ,PA_BUDGET_VERSIONS bv

2210: FROM
2211: (
2212: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2213: FROM PA_RESOURCE_ASSIGNMENTS ra
2214: ,PA_BUDGET_VERSIONS bv
2215: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2216: WHERE ra.project_id = bv.project_id
2217: AND bv.project_id = evs.project_id
2218: AND ra.budget_version_id = bv.budget_version_id

Line 2226: ,PA_BUDGET_VERSIONS bv

2222: AND evs.status_code = 'STRUCTURE_WORKING')
2223: UNION ALL
2224: (SELECT ra.resource_assignment_id, ra.wbs_element_version_id, bv.budget_version_id, bv.project_structure_version_id, ra.task_id
2225: FROM PA_RESOURCE_ASSIGNMENTS ra
2226: ,PA_BUDGET_VERSIONS bv
2227: ,PA_PROJ_ELEM_VER_STRUCTURE evs
2228: ,PA_PROJ_WORKPLAN_ATTR pwa
2229: WHERE pwa.wp_enable_Version_flag = 'N'
2230: AND pwa.project_id = ra.project_id