APPS.PJI_CURR_REP_PERIODS_UTIL dependencies on PJI_SYSTEM_PARAMETERS

Line 76: FROM pji_system_parameters params

72: -- ----------------------------------------------
73: --Count funtion is introduced
74: SELECT COUNT(params.name)
75: INTO l_ent_period_count
76: FROM pji_system_parameters params
77: WHERE 1=1
78: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
79:
80: IF l_ent_period_count = 0

Line 84: INTO pji_system_parameters

80: IF l_ent_period_count = 0
81: THEN
82:
83: INSERT
84: INTO pji_system_parameters
85: (
86: name,
87: value
88: )

Line 96: UPDATE pji_system_parameters

92: p_ent_curr_rep_period
93: );
94: ELSE
95:
96: UPDATE pji_system_parameters
97: SET value = p_ent_curr_rep_period
98: WHERE name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
99:
100: