APPS.PA_COST_PLUS dependencies on PA_TRANSACTION_SOURCES

Line 2025: FROM PA_TRANSACTION_SOURCES PTS

2021: OR
2022: ITEM.Transferred_from_exp_item_id IS NOT NULL /*2217540*/
2023: OR /* 2328366 */
2024: EXISTS (SELECT 1
2025: FROM PA_TRANSACTION_SOURCES PTS
2026: WHERE PTS.Transaction_source = ITEM.Transaction_source
2027: AND PTS.Allow_Burden_Flag = 'Y')
2028: OR ITEM.cost_ind_compiled_set_id is null) /* 3008365 */
2029: AND ITEM.Cost_Dist_Rejection_Code IS NULL

Line 2073: l_allow_burden_flag PA_TRANSACTION_SOURCES.Allow_Burden_Flag%TYPE;

2069: * call to general API for the imported trnasction with
2070: * transaction source. allow burden = 'Y'
2071: *
2072: */
2073: l_allow_burden_flag PA_TRANSACTION_SOURCES.Allow_Burden_Flag%TYPE;
2074: l_api_call_reqd VARCHAR2(1) ;
2075:
2076: -- Bug 3893837 : Introduced cursor to fetch burden cost for adjusted expenditure
2077: -- items from the original expenditure item which is already costed.

Line 2142: FROM PA_TRANSACTION_SOURCES

2138: l_adjusted_item_flag := 'N'; -- Bug 3893837
2139: IF Exp_Item_Row.transaction_source IS NOT NULL THEN
2140: SELECT Allow_Burden_Flag
2141: INTO l_allow_burden_flag
2142: FROM PA_TRANSACTION_SOURCES
2143: WHERE Transaction_Source = Exp_Item_Row.transaction_source;
2144: /* Bug 902578: Fist we calculate the burdened cost using the ratio calculation.
2145: Then we derive the burden cost by subtracting raw cost from burdened cost.
2146: The burden cost (indirect cost) will later be used to calculate total burden cost