APPS.PJI_REP_UTIL dependencies on PJI_SYSTEM_PARAMETERS

Line 2401: pji_system_parameters params,

2397: info.gl_curr_rep_period,
2398: params.value
2399: INTO l_specific_pa_period, l_specific_gl_period, l_specific_ent_period
2400: FROM pji_org_extr_info info,
2401: pji_system_parameters params,
2402: pa_projects_all proj
2403: WHERE proj.project_id = p_project_id
2404: AND info.org_id = proj.org_id
2405: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';

Line 2681: FROM pji_system_parameters params

2677: -- ----------------------------------------------
2678: --Count funtion is introduced
2679: SELECT COUNT(params.name)
2680: INTO l_ent_period_count
2681: FROM pji_system_parameters params
2682: WHERE 1=1
2683: AND params.name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
2684:
2685: IF l_ent_period_count = 0

Line 2689: INTO pji_system_parameters

2685: IF l_ent_period_count = 0
2686: THEN
2687:
2688: INSERT
2689: INTO pji_system_parameters
2690: (
2691: name,
2692: value
2693: )

Line 2701: UPDATE pji_system_parameters

2697: p_ent_curr_rep_period
2698: );
2699: ELSE
2700:
2701: UPDATE pji_system_parameters
2702: SET value = p_ent_curr_rep_period
2703: WHERE name = 'PJI_PJP_ENT_CURR_REP_PERIOD';
2704:
2705: