APPS.PFT_PPROFCAL_MASTER_PUB dependencies on FEM_REGION_INFO

Line 18: g_fem_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';

14:
15: --Constants for output table names being registered with fem_pl_pkg
16: -- API register_table method.
17: g_fem_customer_profit CONSTANT VARCHAR2(30) := 'FEM_CUSTOMER_PROFIT';
18: g_fem_region_info CONSTANT VARCHAR2(30) := 'FEM_REGION_INFO';
19: g_fem_customers_attr CONSTANT VARCHAR2(30) := 'FEM_CUSTOMERS_ATTR';
20:
21: --constant for sql_stmt_type
22: g_insert CONSTANT VARCHAR2(30) := 'INSERT';

Line 1394: FROM fem_region_info

1390: -- Region Counting should be performed only once for a period
1391: BEGIN
1392: SELECT COUNT (region_pct_total_cust)
1393: INTO l_region_percent
1394: FROM fem_region_info
1395: WHERE cal_period_id = p_param_rec.output_cal_period_id
1396: AND ledger_id = p_param_rec.ledger_id
1397: AND dataset_code = p_param_rec.output_dataset_code
1398: AND source_system_code = p_param_rec.source_system_code

Line 1426: ,p_tbl_name => g_fem_region_info

1422: ,p_module => G_BLOCK||'.'||l_api_name
1423: ,p_msg_text => 'Register Table:REGION_COUNTING');
1424:
1425: Register_Table( p_param_rec => p_param_rec
1426: ,p_tbl_name => g_fem_region_info
1427: ,p_num_output_rows => 0
1428: ,p_stmt_type => g_insert);
1429:
1430: -----------------------------------------------------------------------