[Home] [Help]
7470: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ' ,'TRXIMPORT') then
7471:
7472: -- get budget_code_combination_id from pa_budget_lines
7473: -- for the given budget_version_id,project_id,task_id and resource list member id
7474: -- get the resource assignment_id from pa_resource_assignments
7475: -- get the budget_code_combination_id from pa_budget_lines for the
7476: -- given resource assignment id and start date of the gl period
7477: IF p_ext_bdgt_link = 'Y' then
7478: IF g_debug_mode = 'Y' THEN
14911: pra.resource_list_member_id,
14912: pra.task_id,
14913: pbl.period_name --glps.period_name
14914: from pa_budget_lines pbl,
14915: pa_resource_assignments pra--,
14916: --gl_period_statuses glps
14917: where pra.budget_version_id = p_budget_version_id
14918: and pra.project_id = p_project_id -- added to improve performance ..
14919: and pra.budget_version_id = pbl.budget_version_id
14942: pbl.start_date,
14943: pbl.txn_currency_code
14944: from gl_bc_packets glbc,
14945: pa_budget_lines pbl,
14946: pa_resource_assignments pra
14947: where glbc.packet_id = p_packet_id
14948: and pbl.budget_version_id = p_budget_version_id
14949: and pbl.budget_line_id = glbc.source_distribution_id_num_1
14950: and substr(nvl(glbc.result_code,'P'),1,1) = 'F'
14970: pra.resource_list_member_id,
14971: nvl(prlm.parent_member_id,-99) parent_rlmi
14972: from gl_bc_packets glbc,
14973: pa_budget_lines pbl,
14974: pa_resource_assignments pra,
14975: pa_resource_list_members prlm
14976: where glbc.packet_id = p_packet_id
14977: and pbl.budget_version_id = p_budget_version_id
14978: and pbl.budget_line_id = glbc.source_distribution_id_num_1
15433: Begin
15434: select code_combination_id draft_ccid
15435: into t_draft_ccid(x)
15436: from pa_budget_lines bl,
15437: pa_resource_assignments pra
15438: where pra.budget_version_id = l_draft_budget_version_id
15439: and pra.project_id = t_project_id(x)
15440: and pra.task_id = t_task_id(x)
15441: and pra.resource_list_member_id = t_rlmi(x)
15642: Begin
15643: select pbl.code_combination_id into
15644: t_prev_ver_ccid(x)
15645: from pa_budget_lines pbl,
15646: pa_resource_assignments pra
15647: where pbl.start_date = t_budget_start_date(x)
15648: and pbl.txn_currency_code = t_txn_currency_code(x)
15649: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid
15650: and pbl.budget_version_id = pra.budget_version_id
15783: Begin
15784: select pbl.rowid,pbl.code_combination_id into
15785: t_draft_budget_rowid(x),t_draft_ccid(x)
15786: from pa_budget_lines pbl,
15787: pa_resource_assignments pra
15788: where pbl.start_date = t_budget_start_date(x)
15789: and pbl.txn_currency_code = t_txn_currency_code(x)
15790: and pbl.budget_version_id = pra.budget_version_id
15791: and pbl.resource_assignment_id = pra.resource_assignment_id