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_MDP_BDGTS_HDCNT_ORGMGR_CT

Line 107: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

103: WHEN BUDGET_AGGREGATE = ''AVERAGE'' THEN AVG(HEADCOUNT_VALUE)
104: WHEN BUDGET_AGGREGATE = ''MAXIMUM'' THEN MAX(HEADCOUNT_VALUE)
105: ELSE SUM(HEADCOUNT_VALUE)
106: END HEADCOUNT_VALUE
107: FROM HRI_MDP_BDGTS_HDCNT_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

Line 171: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

167: WHEN BUDGET_AGGREGATE = ''AVERAGE'' THEN AVG(HEADCOUNT_VALUE)
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,

Line 292: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

288: WHEN BUDGET_AGGREGATE = ''AVERAGE'' THEN AVG(HEADCOUNT_VALUE)
289: WHEN BUDGET_AGGREGATE = ''MAXIMUM'' THEN MAX(HEADCOUNT_VALUE)
290: ELSE SUM(HEADCOUNT_VALUE)
291: END BUDGETED_AMOUNT
292: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT
293: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
294: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
295: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
296: GROUP BY ORGANIZATION_ID,

Line 383: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

379: WHEN BUDGET_AGGREGATE = 'AVERAGE' THEN AVG(HEADCOUNT_VALUE)
380: WHEN BUDGET_AGGREGATE = 'MAXIMUM' THEN MAX(HEADCOUNT_VALUE)
381: ELSE SUM(HEADCOUNT_VALUE)
382: END,0) budgeted
383: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT
384: WHERE ORGMGR_ID = p_ORGMGR_ID
385: AND EFFECTIVE_START_DATE <= p_effective_end_date
386: AND EFFECTIVE_END_DATE >= p_effective_start_date
387: GROUP BY BUDGET_AGGREGATE,

Line 448: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

444: WHEN BUDGET_AGGREGATE = 'AVERAGE' THEN AVG(HEADCOUNT_VALUE)
445: WHEN BUDGET_AGGREGATE = 'MAXIMUM' THEN MAX(HEADCOUNT_VALUE)
446: ELSE SUM(HEADCOUNT_VALUE)
447: END,0) budgeted
448: FROM HRI_MDP_BDGTS_HDCNT_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

Line 526: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT

522: WHEN BUDGET_AGGREGATE = 'AVERAGE' THEN AVG(HEADCOUNT_VALUE)
523: WHEN BUDGET_AGGREGATE = 'MAXIMUM' THEN MAX(HEADCOUNT_VALUE)
524: ELSE SUM(HEADCOUNT_VALUE)
525: END,0) BUDGETED
526: FROM HRI_MDP_BDGTS_HDCNT_ORGMGR_CT
527: WHERE ORGMGR_ID = p_supervisor_id
528: AND EFFECTIVE_START_DATE <= p_effective_end_date
529: AND EFFECTIVE_END_DATE >= p_effective_start_date
530: AND ORGANIZATION_ID = p_organization_id