APPS.ASO_PROJ_COMM_PVT dependencies on CN_PROJ_COMPENSATION_GTT

Line 295: DELETE FROM CN_PROJ_COMPENSATION_GTT;

291: IF aso_debug_pub.g_debug_flag = 'Y' THEN
292: aso_debug_pub.add('Calc_Proj_Comm: Before Trucate table ',1,'N');
293: END IF;
294: -- Truncate Temp table
295: DELETE FROM CN_PROJ_COMPENSATION_GTT;
296:
297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('Calc_Proj_Comm: Before Insert into table ',1,'N');
299: END IF;

Line 301: INSERT INTO CN_PROJ_COMPENSATION_GTT (

297: IF aso_debug_pub.g_debug_flag = 'Y' THEN
298: aso_debug_pub.add('Calc_Proj_Comm: Before Insert into table ',1,'N');
299: END IF;
300: -- Populate input values into temp table
301: INSERT INTO CN_PROJ_COMPENSATION_GTT (
302: LINE_NUMBER,
303: RESOURCE_ID,
304: PROJECTION_IDENTIFIER,
305: CALC_DATE,

Line 323: INSERT INTO CN_PROJ_COMPENSATION_GTT (

319: AND (B.Quote_Line_Id IS NULL OR B.Quote_Line_Id = A.Quote_Line_Id)
320: GROUP BY A.Quote_Line_Id, B.Resource_Id, A.Inventory_Item_Id,
321: A.Quantity, A.Line_Quote_Price, NVL(A.Currency_Code, C.Currency_Code), A.Line_Category_Code;
322:
323: INSERT INTO CN_PROJ_COMPENSATION_GTT (
324: LINE_NUMBER,
325: RESOURCE_ID,
326: PROJECTION_IDENTIFIER,
327: CALC_DATE,

Line 341: FROM CN_PROJ_COMPENSATION_GTT C);

337: WHERE A.Quote_Header_Id = P_Qte_Header_Rec.Quote_Header_Id
338: AND A.Quote_Header_Id = B.Quote_Header_Id
339: AND A.Quote_Line_Id NOT IN
340: (SELECT C.Line_Number
341: FROM CN_PROJ_COMPENSATION_GTT C);
342:
343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
344: aso_debug_pub.add('Calc_Proj_Comm: Before CN_COMMISSION_CALC_PUB.Calculate_Commission ',1,'N');
345: aso_utility_pvt.print_login_info();