DBA Data[Home] [Help]

APPS.GMS_PA_API3 dependencies on PA_COST_BASE_EXP_TYPES

Line 1083: pa_cost_base_exp_types cbet,

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

Line 1657: pa_cost_base_exp_types cbet,

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

Line 2261: pa_cost_base_exp_types cbet,

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

Line 2402: from pa_cost_base_exp_types cbet

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