APPS.QOT_DEFAULT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 180

     SELECT count(rowid)
     FROM HZ_CUST_ACCOUNTS
     WHERE party_id = l_party
     AND status = 'A'
     AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate))
     		AND trunc(NVL(account_termination_date, sysdate));

Line: 188

     SELECT Cust_Account_Id
     FROM HZ_CUST_ACCOUNTS
     WHERE Party_Id = l_party
     AND status = 'A'
     AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate))
     		AND trunc(NVL(account_termination_date, sysdate));

Line: 196

    SELECT CUST_ACCOUNT_ID
    FROM HZ_CUST_ACCOUNTS
    WHERE Party_id = l_party
    AND status = 'A'
    AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate)) AND
            trunc(NVL(account_termination_date, sysdate))
    AND ROWNUM = 1
    ORDER BY account_activation_date;

Line: 292

     SELECT Price_List_Id
     FROM OE_AGREEMENTS_B
     WHERE Agreement_Id = l_agreement_id
     AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);

Line: 376

     SELECT Price_List_Id
     FROM HZ_CUST_ACCOUNTS
     WHERE Cust_Account_Id = l_acct
     AND Status = 'A';

Line: 382

    SELECT cust_account_id
    FROM ASO_QUOTE_HEADERS_ALL
    WHERE quote_header_id = l_header_id;

Line: 462

     SELECT Price_List_Id
     FROM OE_TRANSACTION_TYPES_ALL
     WHERE Transaction_Type_Id = l_order_type
     AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);

Line: 534

     SELECT Term_Id
     FROM OE_AGREEMENTS_B
     WHERE Agreement_Id = l_agreement_id
     AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);

Line: 605

    select hcp.standard_terms
    from hz_cust_accounts hca,
         hz_customer_profiles hcp
    where  hcp.cust_account_id = hca.cust_account_id
    and    hca.cust_account_id = l_cust_account_id
    and    nvl(hcp.status,'A') = 'A';

Line: 677

         SELECT End_Date
         FROM   GL_PERIODS_V
         WHERE  Period_Type = l_Def_Per
         AND    Period_Set_Name = l_Def_Cal
         AND    SYSDATE BETWEEN NVL(Start_Date,sysdate) AND NVL(End_Date,sysdate);

Line: 767

    SELECT Party_Type
    FROM HZ_PARTIES
    WHERE Party_Id = l_party
    AND Status = 'A';

Line: 773

    SELECT Contact_Point_Id
    FROM HZ_CONTACT_POINTS
    WHERE Owner_Table_Id = l_party
    AND Owner_Table_Name = 'HZ_PARTIES'
    AND Contact_Point_Type = 'PHONE'
    AND Status = 'A'
    AND Primary_Flag = 'Y';

Line: 882

    SELECT Party_Type
    FROM HZ_PARTIES
    WHERE Party_Id = l_party
    AND Status = 'A';

Line: 888

     SELECT A.Party_Site_Id
     FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
     WHERE A.Party_Id = l_party
     AND A.Party_Site_Id = B.Party_Site_Id
     AND B.Site_Use_Type = 'SOLD_TO'
     AND B.Primary_Per_Type = 'Y'
     AND A.Status = 'A'
     AND B.Status = 'A';

Line: 898

     SELECT Party_Site_Id
     FROM HZ_PARTY_SITES
     WHERE Party_Id = l_party
     AND Identifying_Address_Flag = 'Y'
     AND Status = 'A';

Line: 1104

    SELECT Party_Type
    FROM HZ_PARTIES
    WHERE Party_Id = l_party
    AND Status = 'A';

Line: 1110

     SELECT A.Party_Site_Id
     FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
     WHERE A.Party_Id = l_party
     AND A.Party_Site_Id = B.Party_Site_Id
     AND B.Site_Use_Type = 'BILL_TO'
     AND B.Primary_Per_Type = 'Y'
     AND A.Status = 'A'
     AND B.Status = 'A';

Line: 1120

     SELECT Party_Site_Id
     FROM HZ_PARTY_SITES
     WHERE Party_Id = l_party
     AND Identifying_Address_Flag = 'Y'
     AND Status = 'A';

Line: 1331

    SELECT Party_Type
    FROM HZ_PARTIES
    WHERE Party_Id = l_party
    AND Status = 'A';

Line: 1337

     SELECT A.Party_Site_Id
     FROM HZ_PARTY_SITES A, HZ_PARTY_SITE_USES B
     WHERE A.Party_Id = l_party
     AND A.Party_Site_Id = B.Party_Site_Id
     AND B.Site_Use_Type = 'SHIP_TO'
     AND B.Primary_Per_Type = 'Y'
     AND A.Status = 'A'
     AND B.Status = 'A';

Line: 1347

     SELECT Party_Site_Id
     FROM HZ_PARTY_SITES
     WHERE Party_Id = l_party
     AND Identifying_Address_Flag = 'Y'
     AND Status = 'A';

Line: 1565

		SELECT   jrgm.group_id
		FROM     JTF_RS_GROUP_MEMBERS jrgm,
         		JTF_RS_GROUPS_tl jrgt,
         		JTF_RS_GROUP_USAGES jrgu
 		WHERE   jrgm.group_id =jrgt.group_id
 		AND     jrgt.language= userenv('LANG')
 		AND     jrgu.group_id = jrgm.group_id
 		AND     jrgu.usage = 'SALES'
 		AND    nvl(jrgm.delete_flag, 'N') <> 'Y'
 		AND    exists (SELECT 1 FROM
             				jtf_rs_role_relations jrrr
          			WHERE jrrr.role_resource_id= jrgm.group_member_id
          			AND    trunc( nvl(jrrr.start_date_active, SYSDATE))  <= trunc( SYSDATE )
          			AND    trunc( nvl(jrrr.end_date_active, SYSDATE))  >= trunc( SYSDATE )
          			AND    jrrr.role_resource_type='RS_GROUP_MEMBER'
          			AND     nvl(jrrr.delete_flag, 'N') <> 'Y'
          			AND     ROWNUM= 1)
 		AND    jrgm.resource_id = x_resource_id;

Line: 1585

	SELECT j.resource_id
	FROM jtf_rs_salesreps_mo_v srp, jtf_rs_resource_extns_vl j
	WHERE j.user_id = X_User_Id
	AND j.resource_id = srp.resource_id
	AND nvl(srp.status,'A') = 'A'
	AND nvl(trunc(srp.start_date_active), trunc(sysdate)) <= trunc(sysdate)
	AND nvl(trunc(srp.end_date_active), trunc(sysdate)) >= trunc(sysdate)
	AND nvl(trunc(j.start_date_active), trunc(sysdate)) <= trunc(sysdate)
	AND nvl(trunc(j.end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line: 1716

    SELECT resource_id
    FROM JTF_RS_RESOURCE_EXTNS
    WHERE user_id = l_user_id
    AND SYSDATE BETWEEN NVL(start_date_active,sysdate) AND NVL(end_date_active, SYSDATE);

Line: 1722

    SELECT 'Y'
    FROM JTF_RS_SALESREPS_MO_V
    WHERE resource_id = l_res_id
    AND NVL(status,'A') = 'A'
    AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
    AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line: 1730

    SELECT Resource_Id
    FROM JTF_RS_SALESREPS_MO_V
    WHERE salesrep_number = l_Srep
    AND NVL(status,'A') = 'A'
    AND nvl(trunc(start_date_active), trunc(sysdate)) <= trunc(sysdate)
    AND nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);

Line: 1843

	SELECT currency_code
	FROM qp_price_lists_v
	WHERE price_list_id = q_price_list_id;

Line: 1948

     SELECT date_type_preference
     FROM HZ_CUST_ACCOUNTS
     WHERE Cust_Account_Id = l_acct
     AND Status = 'A';

Line: 2018

     SELECT charge_periodicity_code
     FROM mtl_system_items_b
     WHERE organization_id = l_organization
     AND inventory_item_id = l_inventory_item;