APPS.PA_RES_ASG_CURRENCY_PUB dependencies on PA_RESOURCE_ASGN_CURR_S

Line 969: pa_resource_asgn_curr src_rbc

965: src_rbc.TOTAL_PROJFUNC_INIT_REVENUE,
966: src_rbc.TOTAL_DISPLAY_QUANTITY
967: FROM pa_resource_assignments tgt_ra,
968: pa_resource_assignments src_ra,
969: pa_resource_asgn_curr src_rbc
970: WHERE src_rbc.budget_version_id = c_src_version_id
971: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
972: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
973: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 992: pa_resource_asgn_curr src_rbc

988: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
989: src_rbc.TXN_BILL_RATE_OVERRIDE
990: FROM pa_resource_assignments tgt_ra,
991: pa_resource_assignments src_ra,
992: pa_resource_asgn_curr src_rbc
993: WHERE src_rbc.budget_version_id = c_src_version_id
994: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
995: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
996: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 1017: FROM pa_resource_asgn_curr src_rbc,

1013: src_rbc.TXN_CURRENCY_CODE,
1014: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
1015: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
1016: src_rbc.TXN_BILL_RATE_OVERRIDE
1017: FROM pa_resource_asgn_curr src_rbc,
1018: pa_resource_assignments src_ra,
1019: pa_resource_assignments tgt_ra,
1020: pa_resource_asgn_curr_tmp tmp
1021: WHERE tgt_ra.budget_version_id = c_tgt_version_id

Line 1372: pa_resource_asgn_curr_s.nextval,

1368: LAST_UPDATED_BY,
1369: LAST_UPDATE_LOGIN,
1370: RECORD_VERSION_NUMBER )
1371: VALUES (
1372: pa_resource_asgn_curr_s.nextval,
1373: p_fp_cols_rec.x_budget_version_id,
1374: l_ra_id_tab(i),
1375: l_txn_currency_code_tab(i),
1376: l_total_quantity_tab(i),

Line 1429: pa_resource_asgn_curr_s.nextval,

1425: LAST_UPDATED_BY,
1426: LAST_UPDATE_LOGIN,
1427: RECORD_VERSION_NUMBER )
1428: VALUES (
1429: pa_resource_asgn_curr_s.nextval,
1430: p_fp_cols_rec.x_budget_version_id,
1431: l_ra_id_tab(i),
1432: l_txn_currency_code_tab(i),
1433: l_raw_cost_rate_override_tab(i),

Line 1591: pa_resource_asgn_curr_s.nextval,

1587: LAST_UPDATED_BY,
1588: LAST_UPDATE_LOGIN,
1589: RECORD_VERSION_NUMBER )
1590: VALUES (
1591: pa_resource_asgn_curr_s.nextval,
1592: p_fp_cols_rec.x_budget_version_id,
1593: l_ra_id_tab(i),
1594: l_txn_currency_code_tab(i),
1595: l_sysdate,

Line 1651: SELECT pa_resource_asgn_curr_s.nextval,

1647: LAST_UPDATED_BY,
1648: LAST_UPDATE_LOGIN,
1649: RECORD_VERSION_NUMBER,
1650: expenditure_type )--for EnC
1651: SELECT pa_resource_asgn_curr_s.nextval,
1652: p_fp_cols_rec.x_budget_version_id,
1653: tmp.resource_assignment_id,
1654: tmp.txn_currency_code,
1655: tmp.txn_raw_cost_rate_override,

Line 2354: pa_resource_asgn_curr_s.nextval,

2350: LAST_UPDATE_LOGIN,
2351: RECORD_VERSION_NUMBER,
2352: expenditure_type )
2353: VALUES (
2354: pa_resource_asgn_curr_s.nextval,
2355: p_fp_cols_rec.x_budget_version_id,
2356: l_ra_id_tab(i),
2357: l_txn_currency_code_tab(i),
2358: l_total_quantity_tab(i),