DBA Data[Home] [Help]

APPS.FII_AR_PDUE_REC_TREND dependencies on DUAL

Line 34: SELECT fii_time_api.ent_cper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_curr_per_end FROM DUAL;

30: fii_ar_util_pkg.reset_globals;
31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
32:
33: -- Viewby month
34: SELECT fii_time_api.ent_cper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_curr_per_end FROM DUAL;
35: SELECT fii_time_api.ent_pper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_prior_per_end FROM DUAL;
36:
37:
38: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';

Line 35: SELECT fii_time_api.ent_pper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_prior_per_end FROM DUAL;

31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
32:
33: -- Viewby month
34: SELECT fii_time_api.ent_cper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_curr_per_end FROM DUAL;
35: SELECT fii_time_api.ent_pper_end(fii_ar_util_pkg.g_as_of_date) INTO fii_ar_util_pkg.g_prior_per_end FROM DUAL;
36:
37:
38: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
39: fii_ar_util_pkg.populate_summary_gt_tables;