[Home] [Help]
7272: If p_calling_module in ('DISTBTC','DISTERADJ','CBC','EXPENDITURE','DISTCWKST','DISTVIADJ' ,'TRXIMPORT') then
7273:
7274: -- get budget_code_combination_id from pa_budget_lines
7275: -- for the given budget_version_id,project_id,task_id and resource list member id
7276: -- get the resource assignment_id from pa_resource_assignments
7277: -- get the budget_code_combination_id from pa_budget_lines for the
7278: -- given resource assignment id and start date of the gl period
7279: IF p_ext_bdgt_link = 'Y' then
7280: IF g_debug_mode = 'Y' THEN
14489: pra.resource_list_member_id,
14490: pra.task_id,
14491: pbl.period_name --glps.period_name
14492: from pa_budget_lines pbl,
14493: pa_resource_assignments pra--,
14494: --gl_period_statuses glps
14495: where pra.budget_version_id = p_budget_version_id
14496: and pra.project_id = p_project_id -- added to improve performance ..
14497: and pra.budget_version_id = pbl.budget_version_id
14520: pbl.start_date,
14521: pbl.txn_currency_code
14522: from gl_bc_packets glbc,
14523: pa_budget_lines pbl,
14524: pa_resource_assignments pra
14525: where glbc.packet_id = p_packet_id
14526: and pbl.budget_version_id = p_budget_version_id
14527: and pbl.budget_line_id = glbc.source_distribution_id_num_1
14528: and substr(nvl(glbc.result_code,'P'),1,1) = 'F'
14548: pra.resource_list_member_id,
14549: nvl(prlm.parent_member_id,-99) parent_rlmi
14550: from gl_bc_packets glbc,
14551: pa_budget_lines pbl,
14552: pa_resource_assignments pra,
14553: pa_resource_list_members prlm
14554: where glbc.packet_id = p_packet_id
14555: and pbl.budget_version_id = p_budget_version_id
14556: and pbl.budget_line_id = glbc.source_distribution_id_num_1
15002: Begin
15003: select code_combination_id draft_ccid
15004: into t_draft_ccid(x)
15005: from pa_budget_lines bl,
15006: pa_resource_assignments pra
15007: where pra.budget_version_id = l_draft_budget_version_id
15008: and pra.project_id = t_project_id(x)
15009: and pra.task_id = t_task_id(x)
15010: and pra.resource_list_member_id = t_rlmi(x)
15211: Begin
15212: select pbl.code_combination_id into
15213: t_prev_ver_ccid(x)
15214: from pa_budget_lines pbl,
15215: pa_resource_assignments pra
15216: where pbl.start_date = t_budget_start_date(x)
15217: and pbl.txn_currency_code = t_txn_currency_code(x)
15218: and pbl.budget_version_id = pa_budget_fund_pkg.g_cost_prev_bvid
15219: and pbl.budget_version_id = pra.budget_version_id
15352: Begin
15353: select pbl.rowid,pbl.code_combination_id into
15354: t_draft_budget_rowid(x),t_draft_ccid(x)
15355: from pa_budget_lines pbl,
15356: pa_resource_assignments pra
15357: where pbl.start_date = t_budget_start_date(x)
15358: and pbl.txn_currency_code = t_txn_currency_code(x)
15359: and pbl.budget_version_id = pra.budget_version_id
15360: and pbl.resource_assignment_id = pra.resource_assignment_id