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.HRI_OLTP_PMV_HDCNT_ORGMGR dependencies on HRI_CS_SUPH_ORGMGR_CT

Line 112: FROM HRI_CS_SUPH_ORGMGR_CT

108: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
109: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
110: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
111: AND ORGANIZATION_ID IN (SELECT SUB_ORGANIZATION_ID
112: FROM HRI_CS_SUPH_ORGMGR_CT
113: WHERE SUP_PERSON_ID=&HRI_PERSON+HRI_PER_USRDR_H
114: AND SUB_PERSON_ID = SUP_PERSON_ID
115: AND SUB_RELATIVE_LEVEL = 0
116: AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

Line 148: WHERE ORGMGR_ID IN (SELECT SUB_PERSON_ID FROM HRI_CS_SUPH_ORGMGR_CT WHERE SUP_PERSON_ID = &HRI_PERSON+HRI_PER_USRDR_H AND SUB_RELATIVE_LEVEL =1 AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

144: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
145: ,''ACTUAL''
146: ) PREV_ACTUAL
147: FROM HRI_MDP_WRKFC_ORGMGR_MV
148: WHERE ORGMGR_ID IN (SELECT SUB_PERSON_ID FROM HRI_CS_SUPH_ORGMGR_CT WHERE SUP_PERSON_ID = &HRI_PERSON+HRI_PER_USRDR_H AND SUB_RELATIVE_LEVEL =1 AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)
149: AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
150: GROUP BY ORGMGR_ID)
151: UNION ALL
152: (SELECT ORGMGR_ID,

Line 172: WHERE ORGMGR_ID IN (SELECT SUB_PERSON_ID FROM HRI_CS_SUPH_ORGMGR_CT WHERE SUP_PERSON_ID = &HRI_PERSON+HRI_PER_USRDR_H AND SUB_RELATIVE_LEVEL =1 AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

168: WHEN BUDGET_AGGREGATE = ''MAXIMUM'' THEN MAX(HEADCOUNT_VALUE)
169: ELSE SUM(HEADCOUNT_VALUE)
170: END HEADCOUNT_VALUE
171: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT
172: WHERE ORGMGR_ID IN (SELECT SUB_PERSON_ID FROM HRI_CS_SUPH_ORGMGR_CT WHERE SUP_PERSON_ID = &HRI_PERSON+HRI_PER_USRDR_H AND SUB_RELATIVE_LEVEL =1 AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)
173: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
174: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
175: GROUP BY ORGMGR_ID,
176: ORGANIZATION_ID,

Line 453: FROM HRI_CS_SUPH_ORGMGR_CT

449: WHERE ORGMGR_ID = p_ORGMGR_ID
450: AND EFFECTIVE_START_DATE <= p_effective_end_date
451: AND EFFECTIVE_END_DATE >= p_effective_start_date
452: AND ORGANIZATION_ID IN(SELECT SUB_ORGANIZATION_ID
453: FROM HRI_CS_SUPH_ORGMGR_CT
454: WHERE SUP_PERSON_ID=p_ORGMGR_ID
455: AND SUB_PERSON_ID = SUP_PERSON_ID
456: AND SUB_RELATIVE_LEVEL = 0
457: AND p_effective_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

Line 468: FROM HRI_CS_SUPH_ORGMGR_CT

464: FROM HRI_MDP_WRKFC_ORGMGR_MV
465: WHERE ORGMGR_ID = p_ORGMGR_ID
466: AND p_effective_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
467: AND ORGANIZATION_ID IN(SELECT SUB_ORGANIZATION_ID
468: FROM HRI_CS_SUPH_ORGMGR_CT
469: WHERE SUP_PERSON_ID=p_ORGMGR_ID
470: AND SUB_PERSON_ID = SUP_PERSON_ID
471: AND SUB_RELATIVE_LEVEL = 0
472: AND p_effective_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);