DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2815: pa_expenditure_items_all ei,

2811: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2812: FROM
2813: pa_expenditures_all pe,
2814: pa_expenditure_types et,
2815: pa_expenditure_items_all ei,
2816: pa_cost_distribution_lines_all cdl
2817: WHERE
2818: cdl.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id
2819: AND cdl.line_type = x_cdl_line_type

Line 2875: pa_expenditure_items_all ei,

2871: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2872: FROM
2873: pa_expenditures_all pe,
2874: pa_expenditure_types et,
2875: pa_expenditure_items_all ei,
2876: pa_cost_distribution_lines_all cdl
2877: WHERE
2878: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
2879: cdl.project_id = x_start_project_id

Line 2906: pa_expenditure_items_all ei,

2902: gl_date_period_map p,
2903: gl_date_period_map g,
2904: pa_expenditures_all pe,
2905: pa_expenditure_types et,
2906: pa_expenditure_items_all ei,
2907: pa_cost_distribution_lines_all cdl,
2908: pa_implementations pi,
2909: gl_sets_of_books sob
2910: WHERE

Line 3219: pa_expenditure_items_all ei,

3215: decode(et.unit_of_measure,NULL,et.unit_of_measure,ei.unit_of_measure) unit_of_measure
3216: FROM
3217: pa_expenditures_all pe,
3218: pa_expenditure_types et,
3219: pa_expenditure_items_all ei,
3220: pa_cust_rev_dist_lines rdl,
3221: pa_draft_revenues dr
3222: WHERE
3223: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097

Line 3247: pa_expenditure_items_all ei,

3243: gl_date_period_map p,
3244: gl_date_period_map g,
3245: pa_expenditures_all pe,
3246: pa_expenditure_types et,
3247: pa_expenditure_items_all ei,
3248: pa_cust_rev_dist_lines rdl,
3249: pa_draft_revenues dr,
3250: pa_implementations pi,
3251: gl_sets_of_books sob

Line 3670: pa_expenditure_items_all ei,

3666: et.unit_of_measure unit_of_measure
3667: FROM
3668: pa_expenditures_all pe,
3669: pa_expenditure_types et,
3670: pa_expenditure_items_all ei,
3671: pa_cust_rev_dist_lines rdl,
3672: pa_draft_revenues dr
3673: WHERE
3674: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id

Line 4035: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;

4031: l_status VARCHAR2(200) := NULL;
4032: l_stage NUMBER := NULL;
4033:
4034: -- Bug 2119738: New Parameters
4035: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
4036: l_PROJECT_RAW_COST NUMBER := NULL;
4037: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
4038: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
4039: l_PROJFUNC_COST_RATE_DATE DATE := NULL;