DBA Data[Home] [Help]

APPS.GMS_PA_API3 dependencies on PA_IND_COMPILED_SETS

Line 1087: pa_ind_compiled_sets ics,

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,
1088: pa_expenditure_types pet
1089: WHERE cbet.cost_base_type = 'INDIRECT COST'
1090: and pa_currency.round_currency_amt(nvl(l_burdenable_raw_cost(indx),0) * cm.compiled_multiplier) <> 0 --added for bug 6271366
1091: -- and l_acct_raw_cost(indx) <> 0

Line 1661: pa_ind_compiled_sets ics,

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,
1662: pa_expenditure_types pet
1663: WHERE cbet.cost_base_type = 'INDIRECT COST'
1664: and pa_currency.round_currency_amt(nvl(l_burdenable_raw_cost(indx),0) * cm.compiled_multiplier) <> 0 --added for bug 6271366
1665: and l_acct_raw_cost(indx) <> 0

Line 2265: pa_ind_compiled_sets ics,

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,
2266: pa_expenditure_types pet
2267: WHERE cbet.cost_base_type = 'INDIRECT COST'
2268: and pa_currency.round_currency_amt(nvl(l_burdenable_raw_cost(indx),0) * cm.compiled_multiplier) <> 0 --added for bug 6271366
2269: and l_acct_raw_cost(indx) <> 0

Line 2409: PA_IND_COMPILED_SETS ICS

2405: AND cbet.cost_base_type = p_indirect_cost_code
2406: AND cbet.expenditure_type = ITEM.encumbrance_type)
2407: AND EXISTS (SELECT NULL
2408: FROM GMS_ENCUMBRANCES_ALL EXP,
2409: PA_IND_COMPILED_SETS ICS
2410: WHERE EXP.ENCUMBRANCE_ID = ITEM.ENCUMBRANCE_ID
2411: AND ICS.IND_COMPILED_SET_ID = ITEM.IND_COMPILED_SET_ID
2412: AND NVL(ITEM.OVERRIDE_TO_ORGANIZATION_ID, EXP.INCURRED_BY_ORGANIZATION_ID) =ICS.ORGANIZATION_ID
2413: AND ICS.STATUS = 'H'

Line 2661: from pa_ind_compiled_sets ics,

2657: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2658: AND ITEM.ind_compiled_set_id is not null
2659: AND 1 = decode(p_event, 'INSERT', 1
2660: , (select 1
2661: from pa_ind_compiled_sets ics,
2662: pa_ind_rate_sch_revisions irsr
2663: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2664: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2665: and irsr.ind_rate_sch_id = p_ind_rate_sch_id

Line 2755: from pa_ind_compiled_sets ics,

2751: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2752: AND ITEM.ind_compiled_set_id is not null
2753: AND 1 = decode(p_event, 'INSERT', 1
2754: , (select 1
2755: from pa_ind_compiled_sets ics,
2756: pa_ind_rate_sch_revisions irsr
2757: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2758: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2759: and irsr.ind_rate_sch_id = p_ind_rate_sch_id