DBA Data[Home] [Help]

APPS.GMS_PA_API3 dependencies on PA_IND_COMPILED_SETS

Line 1089: pa_ind_compiled_sets ics,

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

Line 1663: pa_ind_compiled_sets ics,

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

Line 2267: pa_ind_compiled_sets ics,

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

Line 2411: PA_IND_COMPILED_SETS ICS

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

Line 2691: from pa_ind_compiled_sets ics,

2687: --bug 7225876 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2688: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2689: AND 1 = decode(p_event, 'INSERT', 1
2690: , (select 1
2691: from pa_ind_compiled_sets ics,
2692: pa_ind_rate_sch_revisions irsr
2693: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2694: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2695: and irsr.ind_rate_sch_id = p_ind_rate_sch_id

Line 2798: from pa_ind_compiled_sets ics,

2794: --bug 7225876 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2795: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2796: AND 1 = decode(p_event, 'INSERT', 1
2797: , (select 1
2798: from pa_ind_compiled_sets ics,
2799: pa_ind_rate_sch_revisions irsr
2800: where ITEM.ind_compiled_set_id = ics.ind_compiled_set_id
2801: and ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id
2802: and irsr.ind_rate_sch_id = p_ind_rate_sch_id