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_RES_ASG_CURRENCY_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 933: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,

929: -- This cursor should be used when p_version_level_flag is 'Y'
930: -- and p_copy_mode is 'COPY_ALL'.
931:
932: CURSOR ver_lvl_copy_all_csr
933: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
934: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
935: SELECT tgt_ra.RESOURCE_ASSIGNMENT_ID,
936: src_rbc.TXN_CURRENCY_CODE,
937: src_rbc.TOTAL_QUANTITY,

Line 934: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

930: -- and p_copy_mode is 'COPY_ALL'.
931:
932: CURSOR ver_lvl_copy_all_csr
933: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
934: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
935: SELECT tgt_ra.RESOURCE_ASSIGNMENT_ID,
936: src_rbc.TXN_CURRENCY_CODE,
937: src_rbc.TOTAL_QUANTITY,
938: src_rbc.TOTAL_INIT_QUANTITY,

Line 967: FROM pa_resource_assignments tgt_ra,

963: src_rbc.TOTAL_PROJFUNC_INIT_RAW_COST,
964: src_rbc.TOTAL_PROJFUNC_INIT_BD_COST,
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

Line 968: pa_resource_assignments src_ra,

964: src_rbc.TOTAL_PROJFUNC_INIT_BD_COST,
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)

Line 983: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,

979: -- This cursor should be used when p_version_level_flag is 'Y'
980: -- and p_copy_mode is 'COPY_OVERRIDES'.
981:
982: CURSOR ver_lvl_copy_overrides_csr
983: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
984: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
985: SELECT tgt_ra.RESOURCE_ASSIGNMENT_ID,
986: src_rbc.TXN_CURRENCY_CODE,
987: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,

Line 984: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

980: -- and p_copy_mode is 'COPY_OVERRIDES'.
981:
982: CURSOR ver_lvl_copy_overrides_csr
983: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
984: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
985: SELECT tgt_ra.RESOURCE_ASSIGNMENT_ID,
986: src_rbc.TXN_CURRENCY_CODE,
987: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
988: src_rbc.TXN_BURDEN_COST_RATE_OVERRIDE,

Line 990: FROM pa_resource_assignments tgt_ra,

986: src_rbc.TXN_CURRENCY_CODE,
987: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
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

Line 991: pa_resource_assignments src_ra,

987: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,
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)

Line 1009: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,

1005: -- Note: Ordered hint has been added to avoid a Merge Join Cartesian
1006: -- join order in the execution plan.
1007:
1008: CURSOR tbl_mode_copy_overrides_csr
1009: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
1010: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1011: SELECT DISTINCT /*+ ORDERED */
1012: tmp.RESOURCE_ASSIGNMENT_ID,
1013: src_rbc.TXN_CURRENCY_CODE,

Line 1010: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

1006: -- join order in the execution plan.
1007:
1008: CURSOR tbl_mode_copy_overrides_csr
1009: ( c_src_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE,
1010: c_tgt_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1011: SELECT DISTINCT /*+ ORDERED */
1012: tmp.RESOURCE_ASSIGNMENT_ID,
1013: src_rbc.TXN_CURRENCY_CODE,
1014: src_rbc.TXN_RAW_COST_RATE_OVERRIDE,

Line 1018: pa_resource_assignments src_ra,

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
1022: AND src_ra.budget_version_id = c_src_version_id

Line 1019: pa_resource_assignments tgt_ra,

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
1022: AND src_ra.budget_version_id = c_src_version_id
1023: AND tgt_ra.resource_assignment_id = tmp.resource_assignment_id

Line 1565: pa_resource_assignments ra

1561: BULK COLLECT
1562: INTO l_ra_id_tab,
1563: l_txn_currency_code_tab
1564: FROM pa_budget_lines bl,
1565: pa_resource_assignments ra
1566: WHERE ra.budget_version_id = p_fp_cols_rec.x_budget_version_id
1567: AND bl.resource_assignment_id = ra.resource_assignment_id
1568: AND NOT EXISTS (SELECT null
1569: FROM pa_resource_asgn_curr rbc

Line 1756: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,

1752: -- The second half gets data for resources that have records in
1753: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1754:
1755: CURSOR version_level_rollup_csr
1756: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1757: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1758: SELECT bl.resource_assignment_id, --RESOURCE_ASSIGNMENT_ID
1759: bl.txn_currency_code, --TXN_CURRENCY_CODE
1760: case when sum(nvl(bl.quantity,0)) = 0 and sum(nvl(bl.init_quantity,0)) = 0 then null else sum(nvl(bl.quantity,0)) end, --TOTAL_QUANTITY

Line 1757: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

1753: -- PA_RESOURCE_ASGN_CURR but no budget lines.
1754:
1755: CURSOR version_level_rollup_csr
1756: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1757: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1758: SELECT bl.resource_assignment_id, --RESOURCE_ASSIGNMENT_ID
1759: bl.txn_currency_code, --TXN_CURRENCY_CODE
1760: case when sum(nvl(bl.quantity,0)) = 0 and sum(nvl(bl.init_quantity,0)) = 0 then null else sum(nvl(bl.quantity,0)) end, --TOTAL_QUANTITY
1761: decode(sum(nvl(bl.init_quantity,0)),

Line 1858: FROM pa_resource_assignments ra,

1854: 0,null,sum(nvl(bl.init_revenue,0))), --TOTAL_PROJFUNC_INIT_REVENUE
1855: decode(sum(nvl(bl.display_quantity,0)),
1856: 0,null,sum(nvl(bl.display_quantity,0))), --TOTAL_DISPLAY_QUANTITY
1857: rbc.expenditure_type --Expenditure type for Enc
1858: FROM pa_resource_assignments ra,
1859: pa_budget_lines bl,
1860: pa_resource_asgn_curr rbc
1861: WHERE bl.resource_assignment_id = rbc.resource_assignment_id (+)
1862: AND bl.txn_currency_code = rbc.txn_currency_code (+)

Line 1923: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,

1919: -- NOTE: the cursor parameters c_project_id and c_budget_version_id
1920: -- are not necessary here, but included in case of future use.
1921:
1922: CURSOR table_level_rollup_csr
1923: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1924: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1925: SELECT /*+ leading(RBC) cardinality(RBC,1) */ -- added hint for bug 14040849
1926: rbc.resource_assignment_id, --RESOURCE_ASSIGNMENT_ID
1927: rbc.txn_currency_code, --TXN_CURRENCY_CODE

Line 1924: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS

1920: -- are not necessary here, but included in case of future use.
1921:
1922: CURSOR table_level_rollup_csr
1923: ( c_project_id PA_RESOURCE_ASSIGNMENTS.PROJECT_ID%TYPE,
1924: c_budget_version_id PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID%TYPE ) IS
1925: SELECT /*+ leading(RBC) cardinality(RBC,1) */ -- added hint for bug 14040849
1926: rbc.resource_assignment_id, --RESOURCE_ASSIGNMENT_ID
1927: rbc.txn_currency_code, --TXN_CURRENCY_CODE
1928: case when sum(nvl(bl.quantity,0)) = 0 and sum(nvl(bl.init_quantity,0)) = 0 then null else sum(nvl(bl.quantity,0)) end, --TOTAL_QUANTITY