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

Line 347: ,pa_resource_assignments ra

343: CURSOR l_lock_old_budget_csr( c_budget_version_id NUMBER )
344: IS
345: SELECT 'x'
346: FROM pa_budget_versions bv
347: ,pa_resource_assignments ra
348: ,pa_budget_lines bl
349: WHERE bv.budget_version_id = c_budget_version_id
350: AND bv.budget_version_id = ra.budget_version_id (+)
351: AND ra.resource_assignment_id = bl.resource_assignment_id (+)

Line 4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;

4075: l_raw_cost NUMBER;
4076: l_burdened_cost NUMBER;
4077: l_revenue NUMBER;
4078: -- Following local variables added as part of bug 3062294
4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes

Line 4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes

4079: l_pa_task_id pa_resource_assignments.task_id%TYPE;
4080: l_pm_task_ref pa_tasks.pm_task_reference%TYPE;
4081: l_resource_alias pa_resource_list_members.alias%TYPE; -- bug 3711693
4082: l_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4083: l_cbs_element_id pa_resource_assignments.cbs_element_id%TYPE;--Bug 16604257 : CBS RBS Phase 2 API changes
4084: l_budget_start_date pa_budget_lines.start_date%TYPE;
4085: l_budget_end_date pa_budget_lines.start_date%TYPE;
4086: l_period_name pa_budget_lines.period_name%TYPE;
4087: l_description pa_budget_lines.description%TYPE;

Line 5094: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c

5090:
5091: BEGIN
5092: SELECT projfunc_currency_code
5093: INTO l_txn_currency_code
5094: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c
5095: WHERE a.project_id = b.project_id
5096: AND b.budget_version_id = c.budget_version_id
5097: AND c.resource_assignment_id = p_resource_assignment_id
5098: AND b.ci_id IS NULL; -- -- Added an extra clause b.ci_id IS NULL --Bug # 3507156

Line 5996: l_plan_start_date pa_resource_assignments.planning_start_date%type;

5992: l_webadi_ci_id pa_budget_versions.ci_id%TYPE;
5993:
5994: l_period_start_date DATE;
5995: l_period_end_date DATE;
5996: l_plan_start_date pa_resource_assignments.planning_start_date%type;
5997: l_plan_end_date pa_resource_assignments.planning_end_date%type;
5998:
5999: TYPE varchr_32_index_date_tbl_typ IS TABLE OF DATE INDEX BY VARCHAR2(32);
6000: TYPE varchr_32_index_varchr_tbl_typ IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(32);

Line 5997: l_plan_end_date pa_resource_assignments.planning_end_date%type;

5993:
5994: l_period_start_date DATE;
5995: l_period_end_date DATE;
5996: l_plan_start_date pa_resource_assignments.planning_start_date%type;
5997: l_plan_end_date pa_resource_assignments.planning_end_date%type;
5998:
5999: TYPE varchr_32_index_date_tbl_typ IS TABLE OF DATE INDEX BY VARCHAR2(32);
6000: TYPE varchr_32_index_varchr_tbl_typ IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(32);
6001:

Line 7632: FROM pa_resource_assignments

7628: SELECT resource_assignment_id,planning_start_date,
7629: planning_end_date,nvl(l_spread_curve_id,spread_curve_id),sp_fixed_date
7630: INTO l_resource_assignment_id,l_planning_start_date,
7631: l_planning_end_date,l_spread_curve_id,l_sp_fixed_date
7632: FROM pa_resource_assignments
7633: WHERE budget_version_id=p_version_info_rec.x_budget_version_id
7634: AND task_id=px_budget_lines_in(i).pa_task_id
7635: AND resource_list_member_id=px_budget_lines_in(i).resource_list_member_id
7636: AND NVL(cbs_element_id,-1)=NVL(px_budget_lines_in(i).cbs_element_id,-1) --16604257

Line 7918: --record in pa_resource_assignments when line is added for first time.

7914: --that we are reading in the below query.
7915: BEGIN
7916: -- We have to handle the no_data_found exception for this select because this select could be fired for
7917: -- caselike from add_budget_line, the budget_line is being added for first time so there wont be any
7918: --record in pa_resource_assignments when line is added for first time.
7919: SELECT pra.planning_start_date,
7920: pra.planning_end_date,
7921: prlm.alias
7922: INTO l_plan_start_date,

Line 7925: FROM pa_resource_assignments pra,

7921: prlm.alias
7922: INTO l_plan_start_date,
7923: l_plan_end_date,
7924: l_resource_alias
7925: FROM pa_resource_assignments pra,
7926: pa_resource_list_members prlm
7927: WHERE pra.budget_version_id = p_version_info_rec.x_budget_version_id
7928: AND pra.resource_list_member_id = px_budget_lines_in(i).resource_list_member_id
7929: AND pra.task_id = px_budget_lines_in(i).pa_task_id

Line 8683: FROM pa_resource_assignments ra , pa_budget_lines bl

8679: DECODE(bl.other_rejection_code,NULL,
8680: DECODE(bl.pfc_cur_conv_rejection_code,NULL,
8681: DECODE(bl.pc_cur_conv_rejection_code,NULL,NULL,'E')
8682: ,'E'),'E'),'E'),'E'),'E') return_status
8683: FROM pa_resource_assignments ra , pa_budget_lines bl
8684: where ra.budget_version_id = p_fin_plan_version_id
8685: and ra.resource_assignment_id = bl.resource_assignment_id;
8686:
8687: BEGIN