APPS.PA_RES_ASG_CURRENCY_PUB dependencies on PA_RESOURCE_ASGN_CURR_S

Line 960: pa_resource_asgn_curr src_rbc

956: src_rbc.TOTAL_PROJFUNC_INIT_REVENUE,
957: src_rbc.TOTAL_DISPLAY_QUANTITY
958: FROM pa_resource_assignments tgt_ra,
959: pa_resource_assignments src_ra,
960: pa_resource_asgn_curr src_rbc
961: WHERE src_rbc.budget_version_id = c_src_version_id
962: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
963: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
964: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 982: pa_resource_asgn_curr src_rbc

978: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
979: src_rbc.TXN_BILL_RATE_OVERRIDE
980: FROM pa_resource_assignments tgt_ra,
981: pa_resource_assignments src_ra,
982: pa_resource_asgn_curr src_rbc
983: WHERE src_rbc.budget_version_id = c_src_version_id
984: AND src_ra.resource_assignment_id = src_rbc.resource_assignment_id
985: AND nvl(tgt_ra.task_id,0) = nvl(src_ra.task_id,0)
986: AND tgt_ra.resource_list_member_id = src_ra.resource_list_member_id

Line 1006: FROM pa_resource_asgn_curr src_rbc,

1002: src_rbc.TXN_CURRENCY_CODE,
1003: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
1004: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,
1005: src_rbc.TXN_BILL_RATE_OVERRIDE
1006: FROM pa_resource_asgn_curr src_rbc,
1007: pa_resource_assignments src_ra,
1008: pa_resource_assignments tgt_ra,
1009: pa_resource_asgn_curr_tmp tmp
1010: WHERE tgt_ra.budget_version_id = c_tgt_version_id

Line 1360: pa_resource_asgn_curr_s.nextval,

1356: LAST_UPDATED_BY,
1357: LAST_UPDATE_LOGIN,
1358: RECORD_VERSION_NUMBER )
1359: VALUES (
1360: pa_resource_asgn_curr_s.nextval,
1361: p_fp_cols_rec.x_budget_version_id,
1362: l_ra_id_tab(i),
1363: l_txn_currency_code_tab(i),
1364: l_total_quantity_tab(i),

Line 1417: pa_resource_asgn_curr_s.nextval,

1413: LAST_UPDATED_BY,
1414: LAST_UPDATE_LOGIN,
1415: RECORD_VERSION_NUMBER )
1416: VALUES (
1417: pa_resource_asgn_curr_s.nextval,
1418: p_fp_cols_rec.x_budget_version_id,
1419: l_ra_id_tab(i),
1420: l_txn_currency_code_tab(i),
1421: l_raw_cost_rate_override_tab(i),

Line 1579: pa_resource_asgn_curr_s.nextval,

1575: LAST_UPDATED_BY,
1576: LAST_UPDATE_LOGIN,
1577: RECORD_VERSION_NUMBER )
1578: VALUES (
1579: pa_resource_asgn_curr_s.nextval,
1580: p_fp_cols_rec.x_budget_version_id,
1581: l_ra_id_tab(i),
1582: l_txn_currency_code_tab(i),
1583: l_sysdate,

Line 1638: SELECT pa_resource_asgn_curr_s.nextval,

1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY,
1636: LAST_UPDATE_LOGIN,
1637: RECORD_VERSION_NUMBER )
1638: SELECT pa_resource_asgn_curr_s.nextval,
1639: p_fp_cols_rec.x_budget_version_id,
1640: tmp.resource_assignment_id,
1641: tmp.txn_currency_code,
1642: tmp.txn_raw_cost_rate_override,

Line 2326: pa_resource_asgn_curr_s.nextval,

2322: LAST_UPDATED_BY,
2323: LAST_UPDATE_LOGIN,
2324: RECORD_VERSION_NUMBER )
2325: VALUES (
2326: pa_resource_asgn_curr_s.nextval,
2327: p_fp_cols_rec.x_budget_version_id,
2328: l_ra_id_tab(i),
2329: l_txn_currency_code_tab(i),
2330: l_total_quantity_tab(i),