DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2713: pa_expenditure_items_all ei,

2709: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2710: FROM
2711: pa_expenditures_all pe,
2712: pa_expenditure_types et,
2713: pa_expenditure_items_all ei,
2714: pa_cost_distribution_lines_all cdl
2715: WHERE
2716: cdl.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id
2717: AND cdl.line_type = x_cdl_line_type

Line 2762: pa_expenditure_items_all ei,

2758: cdl.ind_compiled_set_id cost_ind_compiled_set_id
2759: FROM
2760: pa_expenditures_all pe,
2761: pa_expenditure_types et,
2762: pa_expenditure_items_all ei,
2763: pa_cost_distribution_lines_all cdl
2764: WHERE
2765: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
2766: cdl.project_id = x_start_project_id

Line 2793: pa_expenditure_items_all ei,

2789: gl_date_period_map p,
2790: gl_date_period_map g,
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,
2794: pa_cost_distribution_lines_all cdl,
2795: pa_implementations pi,
2796: gl_sets_of_books sob
2797: WHERE

Line 3039: pa_expenditure_items_all ei,

3035: decode(et.unit_of_measure,NULL,et.unit_of_measure,ei.unit_of_measure) unit_of_measure
3036: FROM
3037: pa_expenditures_all pe,
3038: pa_expenditure_types et,
3039: pa_expenditure_items_all ei,
3040: pa_cust_rev_dist_lines rdl,
3041: pa_draft_revenues dr
3042: WHERE
3043: dr.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id Commented for Bug # 3736097

Line 3067: pa_expenditure_items_all ei,

3063: gl_date_period_map p,
3064: gl_date_period_map g,
3065: pa_expenditures_all pe,
3066: pa_expenditure_types et,
3067: pa_expenditure_items_all ei,
3068: pa_cust_rev_dist_lines rdl,
3069: pa_draft_revenues dr,
3070: pa_implementations pi,
3071: gl_sets_of_books sob

Line 3490: pa_expenditure_items_all ei,

3486: et.unit_of_measure unit_of_measure
3487: FROM
3488: pa_expenditures_all pe,
3489: pa_expenditure_types et,
3490: pa_expenditure_items_all ei,
3491: pa_cust_rev_dist_lines rdl,
3492: pa_draft_revenues dr
3493: WHERE
3494: dr.project_id = x_start_project_id ---- x_start_project_id and x_end_project_id

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

3851: l_status VARCHAR2(200) := NULL;
3852: l_stage NUMBER := NULL;
3853:
3854: -- Bug 2119738: New Parameters
3855: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
3856: l_PROJECT_RAW_COST NUMBER := NULL;
3857: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
3858: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
3859: l_PROJFUNC_COST_RATE_DATE DATE := NULL;