APPS.PJI_PMV_ENGINE dependencies on PJI_SYSTEM_SETTINGS

Line 37: ** in PJI_SYSTEM_SETTINGS

33: /*
34: ** ----------------------------------------------------------
35: ** Function: Convert_AS_OF_DATE
36: ** The function returns hierarchy version id defined in
37: ** in PJI_SYSTEM_SETTINGS
38: ** ----------------------------------------------------------
39: */
40:
41: Function Convert_AS_OF_DATE(p_As_Of_Date NUMBER

Line 125: ** in PJI_SYSTEM_SETTINGS

121: /*
122: ** ----------------------------------------------------------
123: ** Function: Get_Hierarchy_Version_ID
124: ** The function returns hierarchy version id defined in
125: ** in PJI_SYSTEM_SETTINGS
126: ** ----------------------------------------------------------
127: */
128: Function Get_Hierarchy_Version_ID
129: RETURN NUMBER IS

Line 130: l_Org_Structure_Version_ID PJI_SYSTEM_SETTINGS.Org_Structure_Version_ID%TYPE;

126: ** ----------------------------------------------------------
127: */
128: Function Get_Hierarchy_Version_ID
129: RETURN NUMBER IS
130: l_Org_Structure_Version_ID PJI_SYSTEM_SETTINGS.Org_Structure_Version_ID%TYPE;
131: BEGIN
132: IF p_PA_DEBUG_MODE = 'Y' THEN
133: Write2FWKLog('Entering Get_Hierarchy_Version_ID...','Get_Hierarchy_Version_ID');
134: END IF;

Line 139: FROM PJI_SYSTEM_SETTINGS;

135: IF l_Org_Structure_Version_ID IS NULL THEN
136: BEGIN
137: SELECT NVL(org_structure_version_id, -1)
138: INTO l_Org_Structure_Version_ID
139: FROM PJI_SYSTEM_SETTINGS;
140: EXCEPTION
141: WHEN NO_DATA_FOUND THEN
142: RETURN -1;
143: WHEN OTHERS THEN

Line 1471: , pji_system_settings pjist

1467: SELECT subro_organization_id
1468: , name
1469: FROM hri_cs_orghro_v orgd
1470: , hr_all_organization_units_tl org
1471: , pji_system_settings pjist
1472: WHERE 1=1
1473: AND pjist.setting_id = 1
1474: AND orgd.org_hierarchy_version_id = pjist.org_structure_version_id
1475: AND orgd.sub_organization_id = org.organization_id

Line 1496: , pji_system_settings pjist

1492: , name
1493: FROM hri_cs_orghro_v orgd
1494: , hr_all_organization_units_tl org
1495: , per_organization_list sec
1496: , pji_system_settings pjist
1497: WHERE 1=1
1498: AND pjist.setting_id = 1
1499: AND sec.security_profile_id = l_Security_Profile_ID
1500: AND orgd.subro_organization_id = sec.organization_id

Line 2238: FROM pji_system_settings;

2234: IF G_No_Rolling_Weeks IS NULL THEN
2235: BEGIN
2236: SELECT rolling_weeks
2237: INTO G_No_Rolling_Weeks
2238: FROM pji_system_settings;
2239: EXCEPTION
2240: WHEN NO_DATA_FOUND THEN
2241: G_No_Rolling_Weeks:=5;
2242: END;