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 262: ,pa_resource_list_members rl

258: ,rl.alias resource_name
259: ,tmp.txn_currency_code
260: FROM pa_fp_spread_calc_tmp tmp
261: ,pa_resource_assignments ra
262: ,pa_resource_list_members rl
263: WHERE tmp.budget_version_id = p_budget_version_id
264: AND ra.resource_assignment_id = tmp.resource_assignment_id
265: AND rl.resource_list_member_id = ra.resource_list_member_id
266: AND EXISTS (SELECT NULL

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

296: * 5:TABLE ACCESS BY INDEX ROWID PA_BUDGET_LINES :(cost=13,rows=8)
297: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
298: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
299: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
300: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
301: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
302: **/
303: CURSOR cur_blDatesCheck IS
304: SELECT tmp.resource_assignment_id

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

297: * 6:INDEX RANGE SCAN PA_BUDGET_LINES_N3 :(cost=2,rows=1)
298: * 4:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_ASSIGNMENTS :(cost=1,rows=1)
299: * 5:INDEX UNIQUE SCAN PA_RESOURCE_ASSIGNMENTS_U1 :(cost=,rows=1)
300: * 3:TABLE ACCESS BY INDEX ROWID PA_RESOURCE_LIST_MEMBERS :(cost=1,rows=1)
301: * 4:INDEX UNIQUE SCAN PA_RESOURCE_LIST_MEMBERS_U1 :(cost=,rows=1)
302: **/
303: CURSOR cur_blDatesCheck IS
304: SELECT tmp.resource_assignment_id
305: ,rl.alias resource_name

Line 309: ,pa_resource_list_members rl

305: ,rl.alias resource_name
306: ,tmp.txn_currency_code
307: FROM pa_fp_spread_calc_tmp tmp
308: ,pa_resource_assignments ra
309: ,pa_resource_list_members rl
310: WHERE tmp.budget_version_id = p_budget_version_id
311: AND ra.resource_assignment_id = tmp.resource_assignment_id
312: AND rl.resource_list_member_id = ra.resource_list_member_id
313: AND EXISTS (SELECT /*+ NO_UNNEST INDEX (BL,PA_BUDGET_LINES_U1) */ NULL -- Bug#4728472

Line 1225: ,pa_resource_list_members rlm

1221: ,NVL(tmp.delete_bl_flag,'N') delete_bl_flag
1222: FROM pa_fp_spread_calc_tmp tmp
1223: ,pa_fp_spread_calc_tmp2 tmp2
1224: ,pa_resource_assignments ra
1225: ,pa_resource_list_members rlm
1226: WHERE tmp.budget_version_id = p_budget_version_id
1227: AND ra.resource_assignment_id = tmp.resource_assignment_id
1228: AND rlm.resource_list_member_id = ra.resource_list_member_id
1229: AND tmp.resource_assignment_id = tmp2.resource_assignment_id

Line 2688: ,pa_resource_list_members rlm

2684: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
2685: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2686: FROM pa_fp_spread_calc_tmp tmp
2687: ,pa_resource_assignments ra
2688: ,pa_resource_list_members rlm
2689: WHERE ra.budget_version_id = p_budget_version_id
2690: AND ra.resource_assignment_id = tmp.resource_assignment_id
2691: AND rlm.resource_list_member_id = ra.resource_list_member_id
2692: AND NVL(ra.rate_based_flag,'N') <> NVL(ra.resource_rate_based_flag,'N')

Line 2734: ,pa_resource_list_members rlm

2730: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
2731: ,tmp.bill_markup_percentage
2732: FROM pa_fp_spread_calc_tmp tmp
2733: ,pa_resource_assignments ra
2734: ,pa_resource_list_members rlm
2735: WHERE ra.budget_version_id = p_budget_version_id
2736: AND ra.resource_assignment_id = tmp.resource_assignment_id
2737: AND rlm.resource_list_member_id = ra.resource_list_member_id
2738: AND NVL(ra.rate_based_flag,'N') = 'N'

Line 3571: ,pa_resource_list_members rlm

3567: ,NVL(tmp.burden_cost_changed_flag,'N') burden_cost_changed_flag
3568: ,NVL(tmp.revenue_changed_flag,'N') revenue_changed_flag
3569: FROM pa_fp_spread_calc_tmp tmp
3570: ,pa_resource_assignments ra
3571: ,pa_resource_list_members rlm
3572: WHERE ra.budget_version_id = p_budget_version_id
3573: AND ra.resource_assignment_id = tmp.resource_assignment_id
3574: AND rlm.resource_list_member_id = ra.resource_list_member_id
3575: AND NVL(ra.rate_based_flag,'N') = 'Y'

Line 3619: ,pa_resource_list_members rlm

3615: ,tmp.bl_quantity
3616: ,rlm.unit_of_measure uom
3617: FROM pa_fp_spread_calc_tmp tmp
3618: ,pa_resource_assignments ra
3619: ,pa_resource_list_members rlm
3620: WHERE tmp.budget_version_id = p_budget_version_id
3621: AND ra.resource_assignment_id = tmp.resource_assignment_id
3622: AND rlm.resource_list_member_id = ra.resource_list_member_id
3623: AND NVL(ra.rate_based_flag,'N') = 'N'

Line 4360: ,pa_resource_list_members rl

4356: ,ra.planning_end_date
4357: ,rl.alias resource_name
4358: FROM pa_fp_spread_calc_tmp tmp
4359: ,pa_resource_assignments ra
4360: ,pa_resource_list_members rl
4361: WHERE tmp.budget_version_id = p_budget_version_id
4362: AND ra.resource_assignment_id = tmp.resource_assignment_id
4363: AND rl.resource_list_member_id = ra.resource_list_member_id
4364: AND EXISTS ( select null

Line 5939: ,pa_resource_list_members rlm

5935: and tmp1.rlm_id_change_flag = 'Y'))
5936: ,(tmp.task_id,tmp.resource_name) =
5937: (select ra.task_id,rlm.alias
5938: from pa_resource_assignments ra
5939: ,pa_resource_list_members rlm
5940: where ra.resource_assignment_id = tmp.resource_assignment_id
5941: and rlm.resource_list_member_id = ra.resource_list_member_id
5942: )
5943: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'

Line 5977: ,pa_resource_list_members rlm

5973: UPDATE pa_fp_spread_calc_tmp tmp
5974: SET (tmp.task_id,tmp.resource_name) =
5975: (select ra.task_id,rlm.alias
5976: from pa_resource_assignments ra
5977: ,pa_resource_list_members rlm
5978: where ra.resource_assignment_id = tmp.resource_assignment_id
5979: and rlm.resource_list_member_id = ra.resource_list_member_id
5980: )
5981: ,tmp.billable_flag = NVL((select decode(NVL(tmp.billable_flag,'D'),'D'

Line 6167: ,pa_resource_list_members rl

6163: ,tmp.new_sp_fix_date
6164: ,tmp.old_mfc_cost_type_id
6165: ,tmp.new_mfc_cost_type_id
6166: FROM pa_fp_spread_calc_tmp tmp
6167: ,pa_resource_list_members rl
6168: ,pa_resource_assignments ra
6169: WHERE tmp.budget_version_id = p_budget_version_id
6170: AND ra.resource_assignment_id = tmp.resource_assignment_id
6171: AND rl.resource_list_member_id = ra.resource_list_member_id