DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_TRANSACTION_SOURCES

Line 2024: FROM PA_TRANSACTION_SOURCES PTS

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

Line 2072: l_allow_burden_flag PA_TRANSACTION_SOURCES.Allow_Burden_Flag%TYPE;

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

Line 2126: FROM PA_TRANSACTION_SOURCES

2122: l_adjusted_item_flag := 'N'; -- Bug 3893837
2123: IF Exp_Item_Row.transaction_source IS NOT NULL THEN
2124: SELECT Allow_Burden_Flag
2125: INTO l_allow_burden_flag
2126: FROM PA_TRANSACTION_SOURCES
2127: WHERE Transaction_Source = Exp_Item_Row.transaction_source;
2128: /* Bug 902578: Fist we calculate the burdened cost using the ratio calculation.
2129: Then we derive the burden cost by subtracting raw cost from burdened cost.
2130: The burden cost (indirect cost) will later be used to calculate total burden cost