[Home] [Help]
52: WHERE Quote_Header_Id = l_qte_hdr;
53:
54: CURSOR C_Get_Sreps_Count (l_qte_num NUMBER) IS
55: SELECT Count (Resource_Id)
56: FROM ASO_QUOTE_ACCESSES A
57: WHERE A.Quote_Number = l_qte_num
58: AND A.Role_Id IS NOT NULL
59: AND EXISTS
60: ( SELECT B.Resource_Id
723: l_batch_id,
724: A.Resource_Id,
725: A.Role_Id,
726: p_qte_header_rec.quote_header_id
727: FROM ASO_QUOTE_ACCESSES A, CN_SCA_HEADERS_INTERFACE_GTT B
728: WHERE A.Quote_Number = p_qte_header_rec.Quote_Number
729: AND A.Role_Id IS NOT NULL
730: AND EXISTS
731: ( SELECT C.Resource_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
879: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
880: AND A.Resource_Id = C.Resource_Id
935: A.Resource_Grp_Id,
936: l_quota_id,
937: 'Y',
938: NULL
939: FROM ASO_QUOTE_ACCESSES A
940: WHERE A.Resource_Id = p_Qte_Header_Rec.Resource_Id
941: AND A.Quote_Number = p_qte_header_rec.Quote_Number;
942:
943: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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
1004: AND B.SCA_Headers_Interface_Id = A.SCA_Headers_Interface_Id
1005: AND A.Resource_Id = C.Resource_Id
1058: A.Resource_Grp_Id,
1059: l_quota_id,
1060: 'Y',
1061: NULL
1062: FROM ASO_QUOTE_ACCESSES A
1063: WHERE A.Resource_Id = p_Qte_Header_Rec.Resource_Id
1064: AND A.Quote_Number = p_qte_header_rec.Quote_Number;
1065:
1066: END IF; -- l_PSRep