APPS.PA_CAP_INT_PVT dependencies on PA_IND_COST_CODES

Line 80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;

76:
77: -- Globally used variables
78: g_gl_period gl_period_statuses.period_name%TYPE;
79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;
83: g_exp_item_date gl_period_statuses.end_date%TYPE;
84: g_bdgt_entry_level_code varchar2(2) := 'L'; -- Lowest level task

Line 326: lv_exp_type pa_ind_cost_codes.expenditure_type%TYPE;

322: ,p_rate_name IN VARCHAR2
323: ,p_interest_calc_method IN VARCHAR2)
324: RETURN VARCHAR2
325: IS
326: lv_exp_type pa_ind_cost_codes.expenditure_type%TYPE;
327: ln_count NUMBER;
328: BEGIN
329: -- Test for exclusion based on simple interest method
330: IF p_interest_calc_method = 'SIMPLE' THEN

Line 333: FROM pa_ind_cost_codes picc

329: -- Test for exclusion based on simple interest method
330: IF p_interest_calc_method = 'SIMPLE' THEN
331: SELECT picc.expenditure_type
332: INTO lv_exp_type
333: FROM pa_ind_cost_codes picc
334: WHERE picc.ind_cost_code = p_rate_name;
335:
336: IF lv_exp_type = p_exp_type THEN
337: RETURN 'Y';

Line 577: * pa_ind_cost_codes table

573: * again when user runs capint for FEB-02 after migration
574: * ideally p7 should not be picked up for processing. In order to avoid this
575: * the following condition is added : check run irresepective of rate name
576: * for the given project and period and the rate name doesnot exists in the
577: * pa_ind_cost_codes table
578: */
579: OR EXISTS (SELECT 'X'
580: FROM pa_alloc_txn_details patd
581: ,pa_alloc_runs par

Line 591: from pa_ind_cost_codes icc

587: AND par.fiscal_year = p_fiscal_year
588: AND par.rule_id = p_rule_id
589: AND NOT EXISTS ( -- check for override rates which are not migrated
590: select null
591: from pa_ind_cost_codes icc
592: where icc.ind_cost_code = par.cint_rate_name
593: and icc.ind_cost_code_usage = 'CAPITALIZED_INTEREST'
594: )
595: );

Line 1365: ,pa_ind_cost_codes picc

1361: ,pcri.interest_calculation_method interest_calc_method
1362: ,pcri.period_rate_code period_rate_code
1363: ,pcri.fin_plan_type_id fin_plan_type_id
1364: FROM pa_cint_rate_info pcri
1365: ,pa_ind_cost_codes picc
1366: WHERE pcri.ind_cost_code = picc.ind_cost_code
1367: AND picc.ind_cost_code_usage = 'CAPITALIZED_INTEREST'
1368: /* Start Bug fix :3028240
1369: AND /** As discussed with murali the end date of the run period be between the

Line 1420: ,pa_ind_cost_codes picc

1416: ,pcri.period_rate_code period_rate_code
1417: ,pcri.fin_plan_type_id fin_plan_type_id
1418: ,pirs.ind_rate_sch_id interest_sch_id
1419: FROM pa_cint_rate_info pcri
1420: ,pa_ind_cost_codes picc
1421: ,pa_ind_rate_schedules_all_bg pirs
1422: ,pa_ind_rate_sch_revisions pirsv
1423: ,pa_ind_cost_multipliers pccm
1424: WHERE pcri.ind_cost_code = picc.ind_cost_code