APPS.ASO_SALES_CREDIT_PVT dependencies on CN_SCA_LINES_OUTPUT_GTT

Line 471: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

467: WHERE Quota_Flag = 'N';
468:
469: CURSOR C_Get_Total_Revenue (l_batch NUMBER) IS
470: SELECT SUM (NVL(A.Allocation_Percentage,0))
471: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
472: WHERE A.SCA_Batch_Id = l_batch
473: AND A.Revenue_Type = 'REVENUE'
474: AND B.SCA_Batch_Id = l_batch
475: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id

Line 480: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

476: AND B.Source_Line_Id IS NULL;
477:
478: CURSOR C_Get_Line_Revenue (l_batch NUMBER, l_line_id NUMBER) IS
479: SELECT SUM (NVL(A.Allocation_Percentage,0))
480: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
481: WHERE A.SCA_Batch_Id = l_batch
482: AND A.Revenue_Type = 'REVENUE'
483: AND B.SCA_Batch_Id = l_batch
484: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id

Line 489: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

485: AND B.Source_Line_Id = l_line_id;
486:
487: CURSOR C_Get_Hdr_Total (l_batch NUMBER) IS
488: SELECT SUM (NVL(Allocation_Percentage,0))
489: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
490: WHERE A.SCA_Batch_Id = l_batch
491: AND B.SCA_Batch_Id = l_batch
492: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
493: AND B.Source_Line_Id IS NULL;

Line 497: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B

493: AND B.Source_Line_Id IS NULL;
494:
495: CURSOR C_Get_Line_Total (l_batch NUMBER) IS
496: SELECT SUM (NVL(Allocation_Percentage,0))
497: FROM CN_SCA_LINES_OUTPUT_GTT A, CN_SCA_HEADERS_INTERFACE_GTT B
498: WHERE A.SCA_Batch_Id = l_batch
499: AND B.SCA_Batch_Id = l_batch
500: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
501: AND B.Source_Line_Id IS NOT NULL;

Line 562: DELETE FROM CN_SCA_LINES_OUTPUT_GTT;

558: DELETE FROM CN_SCA_LINES_INTERFACE_GTT;
559:
560: DELETE FROM CN_SCA_HEADERS_INTERFACE_GTT;
561:
562: DELETE FROM CN_SCA_LINES_OUTPUT_GTT;
563:
564: IF aso_debug_pub.g_debug_flag = 'Y' THEN
565: aso_debug_pub.add('Get_Credits: After Truncating tables ',1,'N');
566: END IF;

Line 780: select count(*) into l_dumb from CN_SCA_LINES_OUTPUT_GTT;

776: aso_utility_pvt.print_login_info();
777: END IF;
778:
779: IF aso_debug_pub.g_debug_flag = 'Y' THEN
780: select count(*) into l_dumb from CN_SCA_LINES_OUTPUT_GTT;
781: aso_debug_pub.add('Get_Credits: l_dumb: '||l_dumb,1,'N');
782: END IF;
783: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
784: RAISE FND_API.G_EXC_ERROR;

Line 874: FROM CN_SCA_LINES_OUTPUT_GTT A,

870: C.Resource_Grp_Id,
871: Decode(A.Revenue_Type, 'REVENUE', l_quota_id,l_non_quota_id),
872: 'Y',
873: B.Credit_Rule_Id
874: FROM CN_SCA_LINES_OUTPUT_GTT A,
875: CN_SCA_HEADERS_INTERFACE_GTT B,
876: ASO_QUOTE_ACCESSES C
877: WHERE A.SCA_Batch_Id = l_batch_id
878: AND B.SCA_Batch_Id = l_batch_id

Line 999: FROM CN_SCA_LINES_OUTPUT_GTT A,

995: C.Resource_Grp_Id,
996: Decode(A.Revenue_Type, 'REVENUE', l_quota_id,l_non_quota_id),
997: 'Y',
998: B.Credit_Rule_Id
999: FROM CN_SCA_LINES_OUTPUT_GTT A,
1000: CN_SCA_HEADERS_INTERFACE_GTT B,
1001: ASO_QUOTE_ACCESSES C
1002: WHERE A.SCA_Batch_Id = l_batch_id
1003: AND B.SCA_Batch_Id = l_batch_id