APPS.PA_FP_GEN_PUB dependencies on PA_BUDGET_LINES_S

Line 731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;

727: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
728:
729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
734: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
735: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

Line 1317: pa_budget_lines_s.nextval,

1313: LAST_UPDATE_LOGIN,
1314: PROJECT_CURRENCY_CODE,
1315: PROJFUNC_CURRENCY_CODE)
1316: VALUES (
1317: pa_budget_lines_s.nextval,
1318: p_budget_version_id,
1319: l_ins_ra_id_tab(i),
1320: NVL(l_start_date,l_ins_start_date_tab(i)),
1321: l_ins_txn_curr_code_tab(i),

Line 1583: l_target_start_date pa_budget_lines.start_date%TYPE;

1579: l_org_id pa_projects_all.org_id%TYPE;
1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;

Line 1588: l_source_start_date pa_budget_lines.start_date%TYPE;

1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;
1590:
1591: l_prorated_multiplier NUMBER;
1592: l_quantity NUMBER;

Line 1736: pa_budget_lines sbl

1732: l_txn_raw_cost,
1733: l_txn_burdened_cost,
1734: l_txn_revenue
1735: FROM pa_fp_gen_rate_tmp tmp,
1736: pa_budget_lines sbl
1737: WHERE tmp.target_res_asg_id = sbl.resource_assignment_id
1738: and sbl.budget_version_id = l_source_bv_id
1739: and sbl.period_name = l_source_period_name
1740: and sbl.txn_currency_code = decode(p_currency_code_flag,