DBA Data[Home] [Help]

APPS.GMS_PA_API3 dependencies on PA_COST_BASE_EXP_TYPES

Line 1085: pa_cost_base_exp_types cbet,

1081: to_number(null),
1082: 'N',
1083: null
1084: FROM pa_ind_rate_sch_revisions irsr,
1085: pa_cost_base_exp_types cbet,
1086: pa_compiled_multipliers cm,
1087: pa_ind_cost_codes icc,
1088: pa_ind_rate_schedules_all_bg irs,
1089: pa_ind_compiled_sets ics,

Line 1659: pa_cost_base_exp_types cbet,

1655: to_number(null),
1656: 'N',
1657: null
1658: FROM pa_ind_rate_sch_revisions irsr,
1659: pa_cost_base_exp_types cbet,
1660: pa_compiled_multipliers cm,
1661: pa_ind_cost_codes icc,
1662: pa_ind_rate_schedules_all_bg irs,
1663: pa_ind_compiled_sets ics,

Line 2263: pa_cost_base_exp_types cbet,

2259: to_number(null),
2260: 'N',
2261: null
2262: FROM pa_ind_rate_sch_revisions irsr,
2263: pa_cost_base_exp_types cbet,
2264: pa_compiled_multipliers cm,
2265: pa_ind_cost_codes icc,
2266: pa_ind_rate_schedules_all_bg irs,
2267: pa_ind_compiled_sets ics,

Line 2404: from pa_cost_base_exp_types cbet

2400: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2401: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2402: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2403: AND exists (select /*+ NO_UNNEST */ null
2404: from pa_cost_base_exp_types cbet
2405: where cbet.cost_base = p_g_impacted_cost_bases
2406: AND cbet.cost_plus_structure = p_g_cp_structure
2407: AND cbet.cost_base_type = p_indirect_cost_code
2408: AND cbet.expenditure_type = ITEM.encumbrance_type)