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

Line 77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;

73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;
79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
81:

Line 227: pa_resource_assignments ra

223: l_ipm_currency_code_tab,
224: l_rc_rate_override_tab,
225: l_bc_rate_override_tab
226: FROM pa_resource_asgn_curr rbc,
227: pa_resource_assignments ra
228: WHERE rbc.budget_version_id = p_budget_version_id
229: AND rbc.resource_assignment_id = ra.resource_assignment_id
230: AND (ra.transaction_source_code IS NOT NULL
231: OR (ra.transaction_source_code IS NULL

Line 610: pa_resource_assignments ra

606: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
607: INTO l_pfc_burdened_cost,
608: l_pc_burdened_cost
609: FROM pa_fp_rollup_tmp bl,
610: pa_resource_assignments ra
611: WHERE ra.budget_version_id = p_budget_version_id
612: AND ra.resource_assignment_id = bl.resource_assignment_id
613: AND bl.cost_rejection_code is null
614: AND bl.burden_rejection_code is null

Line 647: pa_resource_assignments ra

643: l_res_asg_id_tab,
644: l_start_date_tab,
645: l_txn_currency_code_tab
646: FROM pa_fp_rollup_tmp bl,
647: pa_resource_assignments ra
648: WHERE ra.budget_version_id = p_budget_version_id
649: AND ra.resource_assignment_id = bl.resource_assignment_id
650: AND bl.cost_rejection_code is null
651: AND bl.burden_rejection_code is null

Line 702: pa_resource_assignments ra

698: l_res_asg_id_tab,
699: l_start_date_tab,
700: l_txn_currency_code_tab
701: FROM pa_fp_rollup_tmp bl,
702: pa_resource_assignments ra
703: WHERE ra.budget_version_id = p_budget_version_id
704: AND ra.resource_assignment_id = bl.resource_assignment_id
705: AND bl.start_date >= p_etc_start_date
706: AND bl.cost_rejection_code is null

Line 728: pa_resource_assignments ra

724: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
725: INTO l_pfc_burdened_cost,
726: l_pc_burdened_cost
727: FROM pa_fp_rollup_tmp bl,
728: pa_resource_assignments ra
729: WHERE ra.budget_version_id = p_budget_version_id
730: AND ra.resource_assignment_id = bl.resource_assignment_id
731: AND bl.start_date >= p_etc_start_date
732: AND bl.cost_rejection_code is null

Line 762: pa_resource_assignments ra,

758: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
759: INTO l_pfc_burdened_cost,
760: l_pc_burdened_cost
761: FROM pa_budget_lines bl,
762: pa_resource_assignments ra,
763: pa_tasks ta /* Bug 4546405, ER 4376722 */
764: WHERE bl.budget_version_id = p_budget_version_id
765: AND ra.budget_version_id = p_budget_version_id
766: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 788: pa_resource_assignments ra,

784: nvl(sum(nvl(bl.project_revenue,0)),0)
785: INTO l_pfc_revenue,
786: l_pc_revenue
787: FROM pa_budget_lines bl,
788: pa_resource_assignments ra,
789: pa_tasks ta /* Bug 4546405, ER 4376722 */
790: WHERE bl.budget_version_id = p_budget_version_id
791: AND ra.budget_version_id = p_budget_version_id
792: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 840: pa_resource_assignments ra,

836: l_res_asg_id_tab,
837: l_start_date_tab,
838: l_txn_currency_code_tab
839: FROM pa_budget_lines bl,
840: pa_resource_assignments ra,
841: pa_tasks ta /* Bug 4546405, ER 4376722 */
842: WHERE bl.budget_version_id = p_budget_version_id
843: AND ra.budget_version_id = p_budget_version_id
844: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 902: pa_resource_assignments ra,

898: l_res_asg_id_tab,
899: l_start_date_tab,
900: l_txn_currency_code_tab
901: FROM pa_budget_lines bl,
902: pa_resource_assignments ra,
903: pa_tasks ta /* Bug 4546405, ER 4376722 */
904: WHERE bl.budget_version_id = p_budget_version_id
905: AND ra.budget_version_id = p_budget_version_id
906: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 961: pa_resource_assignments ra,

957: l_res_asg_id_tab,
958: l_start_date_tab,
959: l_txn_currency_code_tab
960: FROM pa_budget_lines bl,
961: pa_resource_assignments ra,
962: pa_tasks ta /* Bug 4546405, ER 4376722 */
963: WHERE bl.budget_version_id = p_budget_version_id
964: AND ra.budget_version_id = p_budget_version_id
965: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 1010: pa_resource_assignments ra,

1006: l_pfc_revenue,
1007: l_pc_burdened_cost,
1008: l_pc_revenue
1009: FROM pa_budget_lines bl,
1010: pa_resource_assignments ra,
1011: pa_tasks ta /* Bug 4546405, ER 4376722 */
1012: WHERE bl.budget_version_id = p_budget_version_id
1013: AND ra.budget_version_id = p_budget_version_id
1014: AND ra.resource_assignment_id = bl.resource_assignment_id

Line 1040: pa_resource_assignments ra,

1036: l_pfc_revenue,
1037: l_pc_burdened_cost,
1038: l_pc_revenue
1039: FROM pa_budget_lines bl,
1040: pa_resource_assignments ra,
1041: pa_tasks ta /* Bug 4546405, ER 4376722 */
1042: WHERE bl.budget_version_id = p_budget_version_id
1043: AND ra.budget_version_id = p_budget_version_id
1044: AND ra.resource_assignment_id = bl.resource_assignment_id