APPS.PJI_AUDIT_RPT dependencies on BIS_COMMON_PARAMETERS

Line 40: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_SET_NAME

36: ';
37:
38: BEGIN
39:
40: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_SET_NAME
41: INTO l_period_set_name
42: FROM dual;
43:
44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE

Line 48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE

44: SELECT PJI_UTILS.GET_EXTRACTION_START_DATE
45: INTO l_global_st_date
46: FROM dual;
47:
48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE
49: INTO l_period_type
50: FROM dual;
51:
52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE

Line 52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE

48: SELECT BIS_COMMON_PARAMETERS.GET_PERIOD_TYPE
49: INTO l_period_type
50: FROM dual;
51:
52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE
53: INTO l_currency_code
54: FROM dual;
55:
56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE

Line 56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE

52: SELECT BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE
53: INTO l_currency_code
54: FROM dual;
55:
56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE
57: INTO l_rate_type
58: FROM dual;
59:
60: SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID

Line 60: SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID

56: SELECT BIS_COMMON_PARAMETERS.GET_RATE_TYPE
57: INTO l_rate_type
58: FROM dual;
59:
60: SELECT BIS_COMMON_PARAMETERS.GET_START_DAY_OF_WEEK_ID
61: INTO l_start_dt_of_week
62: FROM dual;
63:
64: l_bis_param_name_tbl := V_TYPE_TAB();