eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_AVL dependencies on PJI_RM_RES_F

Line 1566: PJI_RM_RES_F FCT,

1562: , AVAILABLE_RES_COUNT_BKT5_S
1563: ) AVAILABLE_DAYS
1564: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1565: PJI_PMV_TIME_DIM_TMP TIME,
1566: PJI_RM_RES_F FCT,
1567: PJI_PMV_ORG_DIM_TMP HOU,
1568: PA_IMPLEMENTATIONS_ALL IMP
1569: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1570: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID

Line 1595: PJI_RM_RES_F FCT,

1591: ,0 AVAILABLE_HOURS
1592: ,0 AVAILABLE_DAYS
1593: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1594: PJI_PMV_TIME_DIM_TMP TIME,
1595: PJI_RM_RES_F FCT,
1596: PJI_PMV_ORG_DIM_TMP HOU,
1597: PA_IMPLEMENTATIONS_ALL IMP
1598: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1599: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID

Line 1629: PJI_RM_RES_F FCT,

1625:
1626: ,0 AVAILABLE_HOURS
1627: ,0 AVAILABLE_DAYS
1628: FROM PJI_PMV_ORGZ_DIM_TMP HORG,
1629: PJI_RM_RES_F FCT,
1630: PJI_PMV_ORG_DIM_TMP HOU
1631: WHERE FCT.EXPENDITURE_ORG_ID = HOU.ID
1632: AND FCT.EXPENDITURE_ORGANIZATION_ID = HORG.ID
1633: AND FCT.TIME_ID = P_AS_OF_DATE

Line 1780: FROM pji_rm_res_f

1776: CASE (l_Threshold)
1777: WHEN 1 THEN
1778: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
1779: INTO P_AVL_RES_DET_TBL(i).available_since
1780: FROM pji_rm_res_f
1781: WHERE 1=1
1782: AND person_id = P_AVL_RES_DET_TBL(i).person_id
1783: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
1784: AND calendar_type = l_Day_Calendar_Type

Line 1791: FROM pji_rm_res_f

1787: AND capacity_hrs <> 0;
1788: WHEN 2 THEN
1789: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
1790: INTO P_AVL_RES_DET_TBL(i).available_since
1791: FROM pji_rm_res_f
1792: WHERE 1=1
1793: AND person_id = P_AVL_RES_DET_TBL(i).person_id
1794: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
1795: AND calendar_type = l_Day_Calendar_Type

Line 1802: FROM pji_rm_res_f

1798: AND capacity_hrs <> 0;
1799: WHEN 3 THEN
1800: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
1801: INTO P_AVL_RES_DET_TBL(i).available_since
1802: FROM pji_rm_res_f
1803: WHERE 1=1
1804: AND person_id = P_AVL_RES_DET_TBL(i).person_id
1805: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
1806: AND calendar_type = l_Day_Calendar_Type

Line 1813: FROM pji_rm_res_f

1809: AND capacity_hrs <> 0;
1810: WHEN 4 THEN
1811: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
1812: INTO P_AVL_RES_DET_TBL(i).available_since
1813: FROM pji_rm_res_f
1814: WHERE 1=1
1815: AND person_id = P_AVL_RES_DET_TBL(i).person_id
1816: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
1817: AND calendar_type = l_Day_Calendar_Type

Line 1824: FROM pji_rm_res_f

1820: AND capacity_hrs <> 0;
1821: WHEN 5 THEN
1822: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
1823: INTO P_AVL_RES_DET_TBL(i).available_since
1824: FROM pji_rm_res_f
1825: WHERE 1=1
1826: AND person_id = P_AVL_RES_DET_TBL(i).person_id
1827: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
1828: AND calendar_type = l_Day_Calendar_Type

Line 1843: FROM pji_rm_res_f fct

1839: CASE (l_Threshold)
1840: WHEN 1 THEN
1841: SELECT MAX(TIME_ID)
1842: INTO l_Available_Week
1843: FROM pji_rm_res_f fct
1844: , fii_time_week time
1845: WHERE 1=1
1846: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
1847: AND time.end_date<=l_Start_Date

Line 1857: FROM pji_rm_res_f fct

1853: AND fct.capacity_hrs <> 0;
1854: WHEN 2 THEN
1855: SELECT MAX(TIME_ID)
1856: INTO l_Available_Week
1857: FROM pji_rm_res_f fct
1858: , fii_time_week time
1859: WHERE 1=1
1860: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
1861: AND time.end_date<=l_Start_Date

Line 1871: FROM pji_rm_res_f fct

1867: AND fct.capacity_hrs <> 0;
1868: WHEN 3 THEN
1869: SELECT MAX(TIME_ID)
1870: INTO l_Available_Week
1871: FROM pji_rm_res_f fct
1872: , fii_time_week time
1873: WHERE 1=1
1874: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
1875: AND time.end_date<=l_Start_Date

Line 1885: FROM pji_rm_res_f fct

1881: AND fct.capacity_hrs <> 0;
1882: WHEN 4 THEN
1883: SELECT MAX(TIME_ID)
1884: INTO l_Available_Week
1885: FROM pji_rm_res_f fct
1886: , fii_time_week time
1887: WHERE 1=1
1888: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
1889: AND time.end_date<=l_Start_Date

Line 1899: FROM pji_rm_res_f fct

1895: AND fct.capacity_hrs <> 0;
1896: WHEN 5 THEN
1897: SELECT MAX(TIME_ID)
1898: INTO l_Available_Week
1899: FROM pji_rm_res_f fct
1900: , fii_time_week time
1901: WHERE 1=1
1902: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
1903: AND time.end_date<=l_Start_Date

Line 1919: FROM pji_rm_res_f fct

1915: CASE (l_Threshold)
1916: WHEN 1 THEN
1917: SELECT MAX(TIME_ID)
1918: INTO l_Available_Week
1919: FROM pji_rm_res_f fct
1920: , fii_time_week time
1921: WHERE 1=1
1922: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
1923: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 1933: FROM pji_rm_res_f fct

1929: AND fct.capacity_hrs <> 0;
1930: WHEN 2 THEN
1931: SELECT MAX(TIME_ID)
1932: INTO l_Available_Week
1933: FROM pji_rm_res_f fct
1934: , fii_time_week time
1935: WHERE 1=1
1936: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
1937: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 1947: FROM pji_rm_res_f fct

1943: AND fct.capacity_hrs <> 0;
1944: WHEN 3 THEN
1945: SELECT MAX(TIME_ID)
1946: INTO l_Available_Week
1947: FROM pji_rm_res_f fct
1948: , fii_time_week time
1949: WHERE 1=1
1950: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
1951: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 1961: FROM pji_rm_res_f fct

1957: AND fct.capacity_hrs <> 0;
1958: WHEN 4 THEN
1959: SELECT MAX(TIME_ID)
1960: INTO l_Available_Week
1961: FROM pji_rm_res_f fct
1962: , fii_time_week time
1963: WHERE 1=1
1964: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
1965: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 1975: FROM pji_rm_res_f fct

1971: AND fct.capacity_hrs <> 0;
1972: WHEN 5 THEN
1973: SELECT MAX(TIME_ID)
1974: INTO l_Available_Week
1975: FROM pji_rm_res_f fct
1976: , fii_time_week time
1977: WHERE 1=1
1978: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
1979: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 2004: FROM pji_rm_res_f

2000: CASE (l_Threshold)
2001: WHEN 1 THEN
2002: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
2003: INTO P_AVL_RES_DET_TBL(i).available_since
2004: FROM pji_rm_res_f
2005: WHERE 1=1
2006: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2007: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2008: AND calendar_type = l_Day_Calendar_Type

Line 2015: FROM pji_rm_res_f

2011: AND capacity_hrs <> 0;
2012: WHEN 2 THEN
2013: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
2014: INTO P_AVL_RES_DET_TBL(i).available_since
2015: FROM pji_rm_res_f
2016: WHERE 1=1
2017: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2018: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2019: AND calendar_type = l_Day_Calendar_Type

Line 2026: FROM pji_rm_res_f

2022: AND capacity_hrs <> 0;
2023: WHEN 3 THEN
2024: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
2025: INTO P_AVL_RES_DET_TBL(i).available_since
2026: FROM pji_rm_res_f
2027: WHERE 1=1
2028: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2029: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2030: AND calendar_type = l_Day_Calendar_Type

Line 2037: FROM pji_rm_res_f

2033: AND capacity_hrs <> 0;
2034: WHEN 4 THEN
2035: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
2036: INTO P_AVL_RES_DET_TBL(i).available_since
2037: FROM pji_rm_res_f
2038: WHERE 1=1
2039: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2040: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2041: AND calendar_type = l_Day_Calendar_Type

Line 2048: FROM pji_rm_res_f

2044: AND capacity_hrs <> 0;
2045: WHEN 5 THEN
2046: SELECT TO_CHAR(TO_DATE(MAX(TIME_ID),'j'),'RRRR/MM/DD')
2047: INTO P_AVL_RES_DET_TBL(i).available_since
2048: FROM pji_rm_res_f
2049: WHERE 1=1
2050: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2051: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2052: AND calendar_type = l_Day_Calendar_Type

Line 2075: FROM pji_rm_res_f

2071: CASE (l_Threshold)
2072: WHEN 1 THEN
2073: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2074: INTO P_AVL_RES_DET_TBL(i).available_since
2075: FROM pji_rm_res_f
2076: WHERE 1=1
2077: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2078: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2079: AND calendar_type = l_Day_Calendar_Type

Line 2086: FROM pji_rm_res_f

2082: AND capacity_hrs <> 0;
2083: WHEN 2 THEN
2084: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2085: INTO P_AVL_RES_DET_TBL(i).available_since
2086: FROM pji_rm_res_f
2087: WHERE 1=1
2088: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2089: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2090: AND calendar_type = l_Day_Calendar_Type

Line 2097: FROM pji_rm_res_f

2093: AND capacity_hrs <> 0;
2094: WHEN 3 THEN
2095: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2096: INTO P_AVL_RES_DET_TBL(i).available_since
2097: FROM pji_rm_res_f
2098: WHERE 1=1
2099: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2100: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2101: AND calendar_type = l_Day_Calendar_Type

Line 2108: FROM pji_rm_res_f

2104: AND capacity_hrs <> 0;
2105: WHEN 4 THEN
2106: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2107: INTO P_AVL_RES_DET_TBL(i).available_since
2108: FROM pji_rm_res_f
2109: WHERE 1=1
2110: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2111: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2112: AND calendar_type = l_Day_Calendar_Type

Line 2119: FROM pji_rm_res_f

2115: AND capacity_hrs <> 0;
2116: WHEN 5 THEN
2117: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2118: INTO P_AVL_RES_DET_TBL(i).available_since
2119: FROM pji_rm_res_f
2120: WHERE 1=1
2121: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2122: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2123: AND calendar_type = l_Day_Calendar_Type

Line 2138: FROM pji_rm_res_f

2134: CASE (l_Threshold)
2135: WHEN 1 THEN
2136: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2137: INTO P_AVL_RES_DET_TBL(i).available_since
2138: FROM pji_rm_res_f
2139: WHERE 1=1
2140: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2141: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2142: AND calendar_type = l_Day_Calendar_Type

Line 2149: FROM pji_rm_res_f

2145: AND capacity_hrs <> 0;
2146: WHEN 2 THEN
2147: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2148: INTO P_AVL_RES_DET_TBL(i).available_since
2149: FROM pji_rm_res_f
2150: WHERE 1=1
2151: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2152: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2153: AND calendar_type = l_Day_Calendar_Type

Line 2160: FROM pji_rm_res_f

2156: AND capacity_hrs <> 0;
2157: WHEN 3 THEN
2158: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2159: INTO P_AVL_RES_DET_TBL(i).available_since
2160: FROM pji_rm_res_f
2161: WHERE 1=1
2162: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2163: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2164: AND calendar_type = l_Day_Calendar_Type

Line 2171: FROM pji_rm_res_f

2167: AND capacity_hrs <> 0;
2168: WHEN 4 THEN
2169: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2170: INTO P_AVL_RES_DET_TBL(i).available_since
2171: FROM pji_rm_res_f
2172: WHERE 1=1
2173: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2174: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2175: AND calendar_type = l_Day_Calendar_Type

Line 2182: FROM pji_rm_res_f

2178: AND capacity_hrs <> 0;
2179: WHEN 5 THEN
2180: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2181: INTO P_AVL_RES_DET_TBL(i).available_since
2182: FROM pji_rm_res_f
2183: WHERE 1=1
2184: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2185: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2186: AND calendar_type = l_Day_Calendar_Type

Line 2240: FROM pji_rm_res_f

2236: l_To_Time_ID:=TO_CHAR(l_Start_date,'j');
2237:
2238: SELECT TO_DATE(MAX(TIME_ID),'j')
2239: INTO l_Available_Date
2240: FROM pji_rm_res_f
2241: WHERE 1=1
2242: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2243: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2244: AND calendar_type = l_Day_Calendar_Type

Line 2252: FROM pji_rm_res_f fct

2248:
2249: IF l_Available_Date IS NULL THEN
2250: SELECT MAX(TIME_ID)
2251: INTO l_Available_Week
2252: FROM pji_rm_res_f fct
2253: , fii_time_week time
2254: WHERE 1=1
2255: AND time.start_date>=l_Start_Date-(7*l_Num_of_Weeks)
2256: AND time.end_date<=l_Start_Date

Line 2267: FROM pji_rm_res_f fct

2263:
2264: IF l_Available_Week IS NULL THEN
2265: SELECT MAX(TIME_ID)
2266: INTO l_Available_Week
2267: FROM pji_rm_res_f fct
2268: , fii_time_week time
2269: WHERE 1=1
2270: AND time.start_date>=l_Start_Date-(7*l_Max_Num_of_Weeks)
2271: AND time.end_date<=l_Start_Date-(7*l_Num_of_Weeks)

Line 2291: FROM pji_rm_res_f

2287: WHERE week_id = l_Available_Week;
2288:
2289: SELECT TO_DATE(MAX(TIME_ID),'j')
2290: INTO l_Available_Date
2291: FROM pji_rm_res_f
2292: WHERE 1=1
2293: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2294: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2295: AND calendar_type = l_Day_Calendar_Type

Line 2355: FROM pji_rm_res_f

2351: l_To_Time_ID:=TO_CHAR(l_End_date,'j');
2352:
2353: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2354: INTO P_AVL_RES_DET_TBL(i).next_asgmt_date
2355: FROM pji_rm_res_f
2356: WHERE 1=1
2357: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2358: AND time_id BETWEEN l_From_Time_ID AND l_To_Time_ID
2359: AND calendar_type = l_Day_Calendar_Type

Line 2367: FROM pji_rm_res_f fct

2363:
2364: IF P_AVL_RES_DET_TBL(i).next_asgmt_date IS NULL THEN
2365: SELECT MIN(TIME_ID)
2366: INTO l_Available_Week
2367: FROM pji_rm_res_f fct
2368: , fii_time_week time
2369: WHERE 1=1
2370: AND time.start_date>=l_End_Date
2371: AND time.end_date<=l_End_Date+(7*l_Num_of_Weeks)

Line 2382: FROM pji_rm_res_f fct

2378:
2379: IF l_Available_Week IS NULL THEN
2380: SELECT MIN(TIME_ID)
2381: INTO l_Available_Week
2382: FROM pji_rm_res_f fct
2383: , fii_time_week time
2384: WHERE 1=1
2385: AND time.start_date>=l_End_Date+(7*l_Num_of_Weeks)
2386: AND time.end_date<=l_End_Date+(7*l_Max_Num_of_Weeks)

Line 2406: FROM pji_rm_res_f

2402: WHERE week_id = l_Available_Week;
2403:
2404: SELECT TO_CHAR(TO_DATE(MIN(TIME_ID),'j'),'RRRR/MM/DD')
2405: INTO P_AVL_RES_DET_TBL(i).next_asgmt_date
2406: FROM pji_rm_res_f
2407: WHERE 1=1
2408: AND person_id = P_AVL_RES_DET_TBL(i).person_id
2409: AND time_id BETWEEN l_To_Time_ID AND l_From_Time_ID
2410: AND calendar_type = l_Day_Calendar_Type