eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_CALC_UTILS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 255: ,pa_resource_list_members rl

251: ,rl.alias resource_name
252: ,tmp.txn_currency_code
253: FROM pa_fp_spread_calc_tmp tmp
254: ,pa_resource_assignments ra
255: ,pa_resource_list_members rl
256: WHERE tmp.budget_version_id = p_budget_version_id
257: AND ra.resource_assignment_id = tmp.resource_assignment_id
258: AND rl.resource_list_member_id = ra.resource_list_member_id
259: AND EXISTS (SELECT NULL

Line 293: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)

289: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
290: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
291: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
292: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
293: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
294: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
295: **/
296: CURSOR cur_blDatesCheck IS
297: SELECT tmp.resource_assignment_id

Line 294: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)

290: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
291: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
292: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
293: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
294: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
295: **/
296: CURSOR cur_blDatesCheck IS
297: SELECT tmp.resource_assignment_id
298: ,rl.alias resource_name

Line 302: ,pa_resource_list_members rl

298: ,rl.alias resource_name
299: ,tmp.txn_currency_code
300: FROM pa_fp_spread_calc_tmp tmp
301: ,pa_resource_assignments ra
302: ,pa_resource_list_members rl
303: WHERE tmp.budget_version_id = p_budget_version_id
304: AND ra.resource_assignment_id = tmp.resource_assignment_id
305: AND rl.resource_list_member_id = ra.resource_list_member_id
306: AND EXISTS (SELECT /*+ NO_UNNEST INDEX (BL,PA_BUDGET_LINES_U1) */ NULL -- Bug#4728472

Line 1218: ,pa_resource_list_members rlm

1214: ,NVL(tmp.delete_bl_flag,'N') delete_bl_flag
1215: FROM pa_fp_spread_calc_tmp tmp
1216: ,pa_fp_spread_calc_tmp2 tmp2
1217: ,pa_resource_assignments ra
1218: ,pa_resource_list_members rlm
1219: WHERE tmp.budget_version_id = p_budget_version_id
1220: AND ra.resource_assignment_id = tmp.resource_assignment_id
1221: AND rlm.resource_list_member_id = ra.resource_list_member_id
1222: AND tmp.resource_assignment_id = tmp2.resource_assignment_id

Line 2679: ,pa_resource_list_members rlm

2675: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2676: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2677: FROM pa_fp_spread_calc_tmp tmp
2678: ,pa_resource_assignments ra
2679: ,pa_resource_list_members rlm
2680: WHERE ra.budget_version_id = p_budget_version_id
2681: AND ra.resource_assignment_id = tmp.resource_assignment_id
2682: AND rlm.resource_list_member_id = ra.resource_list_member_id
2683: AND NVL(ra.rate_based_flag,'N') <> NVL(ra.resource_rate_based_flag,'N')

Line 2725: ,pa_resource_list_members rlm

2721: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2722: ,tmp.bill_markup_percentage
2723: FROM pa_fp_spread_calc_tmp tmp
2724: ,pa_resource_assignments ra
2725: ,pa_resource_list_members rlm
2726: WHERE ra.budget_version_id = p_budget_version_id
2727: AND ra.resource_assignment_id = tmp.resource_assignment_id
2728: AND rlm.resource_list_member_id = ra.resource_list_member_id
2729: AND NVL(ra.rate_based_flag,'N') = 'N'

Line 3543: ,pa_resource_list_members rlm

3539: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
3540: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
3541: FROM pa_fp_spread_calc_tmp tmp
3542: ,pa_resource_assignments ra
3543: ,pa_resource_list_members rlm
3544: WHERE ra.budget_version_id = p_budget_version_id
3545: AND ra.resource_assignment_id = tmp.resource_assignment_id
3546: AND rlm.resource_list_member_id = ra.resource_list_member_id
3547: AND NVL(ra.rate_based_flag,'N') = 'Y'

Line 3591: ,pa_resource_list_members rlm

3587: ,tmp.bl_quantity
3588: ,rlm.unit_of_measure uom
3589: FROM pa_fp_spread_calc_tmp tmp
3590: ,pa_resource_assignments ra
3591: ,pa_resource_list_members rlm
3592: WHERE tmp.budget_version_id = p_budget_version_id
3593: AND ra.resource_assignment_id = tmp.resource_assignment_id
3594: AND rlm.resource_list_member_id = ra.resource_list_member_id
3595: AND NVL(ra.rate_based_flag,'N') = 'N'

Line 4331: ,pa_resource_list_members rl

4327: ,ra.planning_end_date
4328: ,rl.alias resource_name
4329: FROM pa_fp_spread_calc_tmp tmp
4330: ,pa_resource_assignments ra
4331: ,pa_resource_list_members rl
4332: WHERE tmp.budget_version_id = p_budget_version_id
4333: AND ra.resource_assignment_id = tmp.resource_assignment_id
4334: AND rl.resource_list_member_id = ra.resource_list_member_id
4335: AND EXISTS ( select null

Line 5910: ,pa_resource_list_members rlm

5906: and tmp1.rlm_id_change_flag = 'Y'))
5907: ,(tmp.task_id,tmp.resource_name) =
5908: (select ra.task_id,rlm.alias
5909: from pa_resource_assignments ra
5910: ,pa_resource_list_members rlm
5911: where ra.resource_assignment_id = tmp.resource_assignment_id
5912: and rlm.resource_list_member_id = ra.resource_list_member_id
5913: )
5914: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'

Line 5948: ,pa_resource_list_members rlm

5944: UPDATE pa_fp_spread_calc_tmp tmp
5945: SET (tmp.task_id,tmp.resource_name) =
5946: (select ra.task_id,rlm.alias
5947: from pa_resource_assignments ra
5948: ,pa_resource_list_members rlm
5949: where ra.resource_assignment_id = tmp.resource_assignment_id
5950: and rlm.resource_list_member_id = ra.resource_list_member_id
5951: )
5952: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'

Line 6138: ,pa_resource_list_members rl

6134: ,tmp.new_sp_fix_date
6135: ,tmp.old_mfc_cost_type_id
6136: ,tmp.new_mfc_cost_type_id
6137: FROM pa_fp_spread_calc_tmp tmp
6138: ,pa_resource_list_members rl
6139: ,pa_resource_assignments ra
6140: WHERE tmp.budget_version_id = p_budget_version_id
6141: AND ra.resource_assignment_id = tmp.resource_assignment_id
6142: AND rl.resource_list_member_id = ra.resource_list_member_id