eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_PROFILE_AMTS

Line 5550: l_currency_code HZ_CUST_PROFILE_AMTS.currency_code%TYPE;

5546:
5547: l_cust_account_id NUMBER;
5548: l_site_use_id NUMBER;
5549: l_cust_account_profile_id NUMBER;
5550: l_currency_code HZ_CUST_PROFILE_AMTS.currency_code%TYPE;
5551: l_created_by_module HZ_CUST_PROFILE_AMTS.created_by_module%TYPE;
5552: l_application_id NUMBER;
5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;
5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;

Line 5551: l_created_by_module HZ_CUST_PROFILE_AMTS.created_by_module%TYPE;

5547: l_cust_account_id NUMBER;
5548: l_site_use_id NUMBER;
5549: l_cust_account_profile_id NUMBER;
5550: l_currency_code HZ_CUST_PROFILE_AMTS.currency_code%TYPE;
5551: l_created_by_module HZ_CUST_PROFILE_AMTS.created_by_module%TYPE;
5552: l_application_id NUMBER;
5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;
5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;
5555: -- Bug 4770111 : Added for CBM of customer profile

Line 5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;

5549: l_cust_account_profile_id NUMBER;
5550: l_currency_code HZ_CUST_PROFILE_AMTS.currency_code%TYPE;
5551: l_created_by_module HZ_CUST_PROFILE_AMTS.created_by_module%TYPE;
5552: l_application_id NUMBER;
5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;
5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;
5555: -- Bug 4770111 : Added for CBM of customer profile
5556: l_prof_cbm HZ_CUST_PROFILE_AMTS.created_by_module%TYPE := 'TCA_V2_API';
5557:

Line 5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;

5550: l_currency_code HZ_CUST_PROFILE_AMTS.currency_code%TYPE;
5551: l_created_by_module HZ_CUST_PROFILE_AMTS.created_by_module%TYPE;
5552: l_application_id NUMBER;
5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;
5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;
5555: -- Bug 4770111 : Added for CBM of customer profile
5556: l_prof_cbm HZ_CUST_PROFILE_AMTS.created_by_module%TYPE := 'TCA_V2_API';
5557:
5558: -- Added following variables for late charge policy project.

Line 5556: l_prof_cbm HZ_CUST_PROFILE_AMTS.created_by_module%TYPE := 'TCA_V2_API';

5552: l_application_id NUMBER;
5553: l_overall_credit_limit HZ_CUST_PROFILE_AMTS.OVERALL_CREDIT_LIMIT%TYPE;
5554: l_trx_credit_limit HZ_CUST_PROFILE_AMTS.TRX_CREDIT_LIMIT%TYPE;
5555: -- Bug 4770111 : Added for CBM of customer profile
5556: l_prof_cbm HZ_CUST_PROFILE_AMTS.created_by_module%TYPE := 'TCA_V2_API';
5557:
5558: -- Added following variables for late charge policy project.
5559: v_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;

Line 5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;

5556: l_prof_cbm HZ_CUST_PROFILE_AMTS.created_by_module%TYPE := 'TCA_V2_API';
5557:
5558: -- Added following variables for late charge policy project.
5559: v_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;
5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;

Line 5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;

5557:
5558: -- Added following variables for late charge policy project.
5559: v_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;
5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;

Line 5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;

5558: -- Added following variables for late charge policy project.
5559: v_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;
5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;

Line 5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;

5559: v_cust_profile_amt_rec HZ_CUSTOMER_PROFILE_V2PUB.CUST_PROFILE_AMT_REC_TYPE;
5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;
5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;

Line 5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;

5560: l_min_fc_invoice_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_OVERDUE_TYPE%TYPE;
5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;

Line 5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;

5561: l_min_fc_balance_overdue_type HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_OVERDUE_TYPE%TYPE;
5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;

Line 5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;

5562: l_interest_type HZ_CUST_PROFILE_AMTS.INTEREST_TYPE%TYPE;
5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;

Line 5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;

5563: l_penalty_type HZ_CUST_PROFILE_AMTS.PENALTY_TYPE%TYPE;
5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;

Line 5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;

5564: l_exchange_rate_type HZ_CUST_PROFILE_AMTS.EXCHANGE_RATE_TYPE%TYPE;
5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;

Line 5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;

5565: l_min_fc_invoice_amount HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_AMOUNT%TYPE;
5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;

Line 5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;

5566: l_min_fc_invoice_percent HZ_CUST_PROFILE_AMTS.MIN_FC_INVOICE_PERCENT%TYPE;
5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;
5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;

Line 5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;

5567: l_min_fc_balance_amount HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_AMOUNT%TYPE;
5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;
5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;
5575:

Line 5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;

5568: l_min_fc_balance_percent HZ_CUST_PROFILE_AMTS.MIN_FC_BALANCE_PERCENT%TYPE;
5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;
5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;
5575:
5576: BEGIN

Line 5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;

5569: l_interest_rate HZ_CUST_PROFILE_AMTS.INTEREST_RATE%TYPE;
5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;
5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;
5575:
5576: BEGIN
5577:

Line 5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;

5570: l_interest_fixed_amount HZ_CUST_PROFILE_AMTS.INTEREST_FIXED_AMOUNT%TYPE;
5571: l_interest_schedule_id HZ_CUST_PROFILE_AMTS.INTEREST_SCHEDULE_ID%TYPE;
5572: l_penalty_rate HZ_CUST_PROFILE_AMTS.PENALTY_RATE%TYPE;
5573: l_penalty_fixed_amount HZ_CUST_PROFILE_AMTS.PENALTY_FIXED_AMOUNT%TYPE;
5574: l_penalty_schedule_id HZ_CUST_PROFILE_AMTS.PENALTY_SCHEDULE_ID%TYPE;
5575:
5576: BEGIN
5577:
5578: -- Check if API is called in debug mode. If yes, enable debug.

Line 5613: FROM HZ_CUST_PROFILE_AMTS

5609: l_min_fc_invoice_amount, l_min_fc_invoice_percent,
5610: l_min_fc_balance_amount, l_min_fc_balance_percent,
5611: l_interest_rate, l_interest_fixed_amount, l_interest_schedule_id,
5612: l_penalty_rate, l_penalty_fixed_amount, l_penalty_schedule_id
5613: FROM HZ_CUST_PROFILE_AMTS
5614: WHERE ROWID = p_rowid;
5615: END IF;
5616:
5617: --------------------------------------

Line 5633: FROM HZ_CUST_PROFILE_AMTS

5629: p_cust_profile_amt_rec.cust_acct_profile_amt_id <> FND_API.G_MISS_NUM
5630: THEN
5631: BEGIN
5632: SELECT 'Y' INTO l_dummy
5633: FROM HZ_CUST_PROFILE_AMTS
5634: WHERE CUST_ACCT_PROFILE_AMT_ID = p_cust_profile_amt_rec.cust_acct_profile_amt_id;
5635:
5636: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
5637: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_acct_profile_amt_id' );

Line 5924: FROM HZ_CUST_PROFILE_AMTS

5920:
5921: IF p_create_update_flag = 'C' THEN
5922: BEGIN
5923: SELECT 'Y' INTO l_dummy
5924: FROM HZ_CUST_PROFILE_AMTS
5925: WHERE CUST_ACCOUNT_PROFILE_ID = p_cust_profile_amt_rec.cust_account_profile_id
5926: AND CURRENCY_CODE = p_cust_profile_amt_rec.currency_code
5927: AND ROWNUM = 1;
5928: