APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_BUDGET_LINES

Line 884: from pa_budget_lines pbl

880: AND ( ra.transaction_source_code is not null
881: OR
882: (ra.transaction_source_code is null and NOT exists
883: ( select 1
884: from pa_budget_lines pbl
885: where pbl.resource_assignment_id = ra.resource_assignment_id
886: and pbl.start_date >= l_etc_start_date
887: )
888: )

Line 901: from pa_budget_lines pbl

897: AND ( ra.transaction_source_code is not null
898: OR
899: (ra.transaction_source_code is null and NOT exists
900: ( select 1
901: from pa_budget_lines pbl
902: where pbl.resource_assignment_id = ra.resource_assignment_id
903: )
904: )
905: );

Line 2094: (p_resource_assignment_id pa_budget_lines.resource_assignment_id%type,

2090: order by 1,2;
2091:
2092: -- Cursor to check whether budget line already exists for the period
2093: cursor budget_line_info_csr
2094: (p_resource_assignment_id pa_budget_lines.resource_assignment_id%type,
2095: p_period_name pa_budget_lines.period_name%type,
2096: p_txn_currency_code pa_budget_lines.txn_currency_code%type)
2097: is
2098: SELECT bl.budget_line_id

Line 2095: p_period_name pa_budget_lines.period_name%type,

2091:
2092: -- Cursor to check whether budget line already exists for the period
2093: cursor budget_line_info_csr
2094: (p_resource_assignment_id pa_budget_lines.resource_assignment_id%type,
2095: p_period_name pa_budget_lines.period_name%type,
2096: p_txn_currency_code pa_budget_lines.txn_currency_code%type)
2097: is
2098: SELECT bl.budget_line_id
2099: ,bl.resource_assignment_id

Line 2096: p_txn_currency_code pa_budget_lines.txn_currency_code%type)

2092: -- Cursor to check whether budget line already exists for the period
2093: cursor budget_line_info_csr
2094: (p_resource_assignment_id pa_budget_lines.resource_assignment_id%type,
2095: p_period_name pa_budget_lines.period_name%type,
2096: p_txn_currency_code pa_budget_lines.txn_currency_code%type)
2097: is
2098: SELECT bl.budget_line_id
2099: ,bl.resource_assignment_id
2100: ,bl.txn_currency_code

Line 2121: FROM pa_budget_lines bl

2117: ,bl.revenue_rejection_code
2118: ,bl.burden_rejection_code
2119: ,bl.pfc_cur_conv_rejection_code
2120: ,bl.pc_cur_conv_rejection_code
2121: FROM pa_budget_lines bl
2122: WHERE bl.resource_assignment_id = p_resource_assignment_id
2123: AND bl.period_name = NVL(p_period_name,bl.period_name)
2124: AND bl.txn_currency_code = p_txn_currency_code;
2125:

Line 2684: Check whether budget lines are available in pa_budget_lines for

2680: Getting relevant resource assignment ids - End
2681: -----------------------------------------------------------------*/
2682:
2683: /*---------------------------------------------------------------
2684: Check whether budget lines are available in pa_budget_lines for
2685: all period for each resource assignment present in
2686: PJI_FM_XBS_ACCUM_TMP1 temp table. If budget line is not present,
2687: create budget line.
2688: -----------------------------------------------------------------*/

Line 2718: INSERT INTO PA_BUDGET_LINES(BUDGET_VERSION_ID,

2714: l_fp_cols_rec.x_set_of_books_id);
2715: fetch pa_period_start_end_dates_csr into l_start_date, l_end_date;
2716: close pa_period_start_end_dates_csr;
2717: end if;
2718: INSERT INTO PA_BUDGET_LINES(BUDGET_VERSION_ID,
2719: RESOURCE_ASSIGNMENT_ID,
2720: START_DATE,
2721: END_DATE,
2722: LAST_UPDATE_DATE,

Line 2747: PA_BUDGET_LINES_S.nextval,

2743: l_sysdate,
2744: l_last_updated_by,
2745: l_last_update_login,
2746: period_info_rec.period_name,
2747: PA_BUDGET_LINES_S.nextval,
2748: period_info_rec.txn_currency_code,
2749: PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,
2750: PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,
2751: PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,