APPS.AR_CMGT_DATA_POINTS_PKG dependencies on AR_CMGT_SETUP_OPTIONS

Line 2058: FROM AR_CMGT_SETUP_OPTIONS sys,

2054: p_resultout OUT NOCOPY VARCHAR2) IS
2055:
2056: CURSOR aging_cur IS
2057: SELECT age.aging_bucket_id,age.aging_bucket_line_id
2058: FROM AR_CMGT_SETUP_OPTIONS sys,
2059: ar_aging_bucket_lines age
2060: WHERE sys.aging_bucket_id = age.aging_bucket_id;
2061:
2062: l_outstanding_balance NUMBER;

Line 2136: FROM AR_CMGT_SETUP_OPTIONS sys,

2132: SELECT age.bucket_name,
2133: default_exchange_rate_type
2134: INTO l_bucket_name,
2135: l_exchange_rate_type
2136: FROM AR_CMGT_SETUP_OPTIONS sys,
2137: ar_aging_buckets age
2138: WHERE sys.aging_bucket_id = age.aging_bucket_id;
2139: EXCEPTION
2140: WHEN others THEN

Line 4556: FROM ar_cmgt_setup_options;

4552:
4553: CURSOR getRateTypeFromSetup
4554: IS
4555: SELECT default_exchange_rate_type
4556: FROM ar_cmgt_setup_options;
4557:
4558: l_rule_id NUMBER;
4559: l_source_name VARCHAR2(50);
4560: l_exchange_rate_type VARCHAR2(50);

Line 4616: l_certified_dso_days ar_cmgt_setup_options.cer_dso_days%type;

4612:
4613: l_curr_array_list curr_array_type;
4614: l_check_list_id ar_cmgt_check_lists.check_list_id%type;
4615: summary_rec_str VARCHAR2(4000);
4616: l_certified_dso_days ar_cmgt_setup_options.cer_dso_days%type;
4617: l_data_point_id NUMBER;
4618: l_data_point_name ar_cmgt_data_points_vl.data_point_name%type;
4619: l_case_folder_id NUMBER;
4620: l_error_msg VARCHAR2(4000);

Line 4622: l_period ar_cmgt_setup_options.period%type;

4618: l_data_point_name ar_cmgt_data_points_vl.data_point_name%type;
4619: l_case_folder_id NUMBER;
4620: l_error_msg VARCHAR2(4000);
4621: l_resultout VARCHAR2(2000);
4622: l_period ar_cmgt_setup_options.period%type;
4623: l_data_point_value ar_cmgt_cf_dtls.data_point_value%type;
4624: l_start_pos NUMBER;
4625: l_end_pos NUMBER;
4626: l_combo_string VARCHAR2(100);

Line 4635: l_exchange_rate_type ar_cmgt_setup_options.default_exchange_rate_type%type;

4631: l_limit_currency VARCHAR2(30);
4632: l_include_all_flag VARCHAR2(1);
4633: l_curr_tbl HZ_CREDIT_USAGES_PKG.curr_tbl_type;
4634: l_excl_curr_list VARCHAR2(2000);
4635: l_exchange_rate_type ar_cmgt_setup_options.default_exchange_rate_type%type;
4636: l_overall_limit NUMBER;
4637: l_cust_acct_profile_amt_id NUMBER;
4638: l_case_folder_id_1 number;
4639: l_dso number;

Line 5695: FROM ar_cmgt_setup_options;

5691: -- Get values from system parameters
5692: BEGIN
5693: SELECT period, cer_dso_days
5694: INTO l_period, l_certified_dso_days
5695: FROM ar_cmgt_setup_options;
5696:
5697: EXCEPTION
5698: WHEN OTHERS
5699: THEN