APPS.OZF_AUTOPAY_PVT SQL Statements

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

Line: 11

G_UPDATE_EVENT          CONSTANT VARCHAR2(30) := 'UPDATE';

Line: 34

  SELECT trade_profile_id,
         cust_account_id,
         site_use_id,
         payment_method,
         vendor_id,
         vendor_site_id,
         last_paid_date,
         autopay_periodicity,
         autopay_periodicity_type,
         autopay_flag,
         claim_threshold,
         claim_currency,
         org_id
  FROM ozf_cust_trd_prfls_all
  WHERE site_use_id = p_id;

Line: 51

  SELECT trade_profile_id,
         cust_account_id,
         site_use_id,
         payment_method,
         vendor_id,
         vendor_site_id,
         last_paid_date,
         autopay_periodicity,
         autopay_periodicity_type,
         autopay_flag,
         claim_threshold,
         claim_currency,
         org_id
  FROM ozf_cust_trd_prfls
  WHERE cust_account_id = p_id
  AND site_use_id IS NULL;

Line: 69

  SELECT trade_profile_id,
         cust_account_id,
         site_use_id,
         payment_method,
         vendor_id,
         vendor_site_id,
         last_paid_date,
         autopay_periodicity,
         autopay_periodicity_type,
         autopay_flag,
         claim_threshold,
         claim_currency,
         org_id
  FROM ozf_cust_trd_prfls
  WHERE party_id = p_id
  AND cust_account_id IS NULL;

Line: 106

  SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
  FROM hz_cust_accounts ca
  ,    hz_parties party
  WHERE ca.party_id = party.party_id
  AND ca.cust_account_id = cv_cust_account_id;

Line: 298

  SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
  FROM hz_cust_accounts ca
  ,    hz_parties party
  WHERE ca.party_id = party.party_id
  AND ca.cust_account_id = cv_cust_account_id;

Line: 307

  select object_version_number, sales_rep_id
  from ozf_claims_all
  where claim_id = p_claim_id;

Line: 320

  SELECT salesrep_required_flag
  FROM ar_system_parameters;

Line: 326

  SELECT claim_number, amount, cust_billto_acct_site_id
  FROM ozf_claims
  WHERE claim_id = cv_claim_id;

Line: 494

            OZF_claim_PVT.Update_claim(
               P_Api_Version                => 1.0,
               P_Init_Msg_List              => FND_API.G_FALSE,
               P_Commit                     => FND_API.G_FALSE,
               P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
               X_Return_Status              => l_return_status,
               X_Msg_Count                  => l_msg_count,
               X_Msg_Data                   => l_msg_data,
               P_claim                      => l_claim_settle_Rec,
               p_event                      => 'UPDATE',
               p_mode                       => OZF_claim_Utility_pvt.G_AUTO_MODE,
               X_Object_Version_Number      => l_object_version_number
            );

Line: 594

SELECT autopay_flag
,      autopay_reason_code_id
,      autopay_claim_type_id
,      autopay_periodicity
,      autopay_periodicity_type
FROM ozf_sys_parameters;

Line: 610

  select settlement_code
  from ozf_offer_adjustments_b
  where list_header_id = p_id;

Line: 774

    p_select_cust_children_flag     IN VARCHAR2  := 'N',
    p_pay_to_customer               IN VARCHAR2 := NULL,
    p_fund_id                       IN NUMBER   := NULL,
    p_plan_type                     IN VARCHAR2 := NULL,
    p_offer_type                    IN VARCHAR2 := NULL,
    p_plan_id                       IN NUMBER   := NULL,
    p_product_category_id           IN NUMBER   := NULL,
    p_product_id                    IN NUMBER   := NULL,
    p_end_date                      IN VARCHAR2,
    p_group_by_offer                IN VARCHAR2
)
IS
l_return_status          varchar2(1);

Line: 795

SELECT autopay_flag
,      autopay_reason_code_id
,      autopay_claim_type_id
,      autopay_periodicity
,      autopay_periodicity_type
FROM ozf_sys_parameters;

Line: 824

SELECT MEANING
FROM OZF_LOOKUPS
WHERE lookup_type = lkup_type
AND LOOKUP_CODE = lkup_code;

Line: 830

SELECT ar.MEANING
FROM ar_lookups ar
WHERE ar.lookup_type = 'RELATIONSHIP_TYPE'
AND ar.lookup_code = lkup_code;

Line: 836

SELECT MEANING
FROM FND_LOOKUPS
WHERE lookup_type = lkup_type
AND LOOKUP_CODE = lkup_code;

Line: 842

SELECT f.SHORT_NAME
FROM OZF_FUNDS_VL f
WHERE f.FUND_ID = p_fund_id;

Line: 847

SELECT QP.DESCRIPTION
FROM QP_LIST_HEADERS_VL qp
WHERE qp.list_header_id = off_id;

Line: 852

SELECT  MCT.DESCRIPTION
FROM MTL_CATEGORIES_TL MCT
WHERE  MCT.CATEGORY_ID = prod_cat_id;

Line: 857

SELECT DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV
WHERE INVENTORY_ITEM_ID = p_product_id
AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

Line: 863

  SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
  FROM hz_cust_accounts ca
  ,    hz_parties party
  WHERE ca.party_id = party.party_id
  AND ca.cust_account_id = cv_cust_account_id;

Line: 870

  SELECT party_id
  FROM hz_cust_accounts
  WHERE cust_account_id = cv_cust_account_id;

Line: 875

  SELECT party_name
  FROM hz_parties
  WHERE party_id = cv_party_id;

Line: 880

  SELECT meaning
  FROM ozf_lookups
  WHERE lookup_type = 'OZF_AUTOPAY_METHOD'
  AND lookup_code = cv_payment_method;

Line: 887

    SELECT ou.organization_id   org_id
    FROM hr_operating_units ou
    WHERE mo_global.check_access(ou.organization_id) = 'Y';

Line: 1002

                   IF p_select_cust_children_flag IS NOT NULL THEN
                          OPEN csr_members('YES_NO', p_select_cust_children_flag);

Line: 1112

                   l_funds_util_flt.select_cust_children_flag := p_select_cust_children_flag;

Line: 1419

                        UPDATE OZF_CUST_TRD_PRFLS_ALL
                           SET last_paid_date   = SYSDATE
                         WHERE trade_profile_id = l_trd_prof_tbl(i) ;