APPS.PA_FP_GEN_PUB dependencies on PA_BUDGET_LINES_S

Line 744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;

740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

Line 1330: pa_budget_lines_s.nextval,

1326: LAST_UPDATE_LOGIN,
1327: PROJECT_CURRENCY_CODE,
1328: PROJFUNC_CURRENCY_CODE)
1329: VALUES (
1330: pa_budget_lines_s.nextval,
1331: p_budget_version_id,
1332: l_ins_ra_id_tab(i),
1333: NVL(l_start_date,l_ins_start_date_tab(i)),
1334: l_ins_txn_curr_code_tab(i),

Line 1596: l_target_start_date pa_budget_lines.start_date%TYPE;

1592: l_org_id pa_projects_all.org_id%TYPE;
1593: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;

Line 1601: l_source_start_date pa_budget_lines.start_date%TYPE;

1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;
1602: l_source_end_date pa_budget_lines.end_date%TYPE;
1603:
1604: l_prorated_multiplier NUMBER;
1605: l_quantity NUMBER;

Line 1749: pa_budget_lines sbl

1745: l_txn_raw_cost,
1746: l_txn_burdened_cost,
1747: l_txn_revenue
1748: FROM pa_fp_gen_rate_tmp tmp,
1749: pa_budget_lines sbl
1750: WHERE tmp.target_res_asg_id = sbl.resource_assignment_id
1751: and sbl.budget_version_id = l_source_bv_id
1752: and sbl.period_name = l_source_period_name
1753: and sbl.txn_currency_code = decode(p_currency_code_flag,