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_LBRCST_ORGMGR dependencies on HRI_CS_SUPH_ORGMGR_CT

Line 335: FROM HRI_CS_SUPH_ORGMGR_CT

331: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
332: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
333: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
334: AND ORGANIZATION_ID IN (SELECT SUB_ORGANIZATION_ID
335: FROM HRI_CS_SUPH_ORGMGR_CT
336: WHERE SUP_PERSON_ID=&HRI_PERSON+HRI_PER_USRDR_H
337: AND SUB_PERSON_ID = SUP_PERSON_ID
338: AND SUB_RELATIVE_LEVEL = 0
339: AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

Line 371: FROM HRI_CS_SUPH_ORGMGR_CT

367: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
368: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
369: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
370: AND ORGANIZATION_ID IN (SELECT SUB_ORGANIZATION_ID
371: FROM HRI_CS_SUPH_ORGMGR_CT
372: WHERE SUP_PERSON_ID=&HRI_PERSON+HRI_PER_USRDR_H
373: AND SUB_PERSON_ID = SUP_PERSON_ID
374: AND SUB_RELATIVE_LEVEL = 0
375: AND &BIS_CURRENT_ASOF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)

Line 433: 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)

429: ,''CMMT''
430: ) ,
431: '''||l_rateType||''') PREV_COMMITED
432: FROM HRI_MDP_CMNTS_ACTLS_MV
433: 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)
434: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
435: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
436: GROUP BY ORGMGR_ID,
437: CURRENCY_CODE )

Line 462: 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)

458: null COMMITTED_AMOUNT,
459: null PREV_ACTUAL,
460: null PREV_COMMITED
461: FROM HRI_MDP_BDGTS_LBRCST_MV
462: 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)
463: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
464: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
465: GROUP BY ORGMGR_ID,
466: CURRENCY_CODE )

Line 560: FROM HRI_CS_SUPH_ORGMGR_CT

556: WHERE bdg.ORGMGR_ID = p_ORGMGR_ID
557: AND bdg.EFFECTIVE_START_DATE <= p_effective_end_date
558: AND bdg.EFFECTIVE_END_DATE >= p_effective_start_date
559: AND ORGANIZATION_ID IN (SELECT SUB_ORGANIZATION_ID
560: FROM HRI_CS_SUPH_ORGMGR_CT
561: WHERE SUP_PERSON_ID=p_ORGMGR_ID
562: AND SUB_PERSON_ID = SUP_PERSON_ID
563: AND SUB_RELATIVE_LEVEL = 0
564: AND p_effective_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);

Line 575: FROM HRI_CS_SUPH_ORGMGR_CT

571: WHERE act.ORGMGR_ID = p_ORGMGR_ID
572: AND act.EFFECTIVE_START_DATE <= p_effective_end_date
573: AND act.EFFECTIVE_END_DATE >= p_effective_start_date
574: AND ORGANIZATION_ID IN (SELECT SUB_ORGANIZATION_ID
575: FROM HRI_CS_SUPH_ORGMGR_CT
576: WHERE SUP_PERSON_ID=p_ORGMGR_ID
577: AND SUB_PERSON_ID = SUP_PERSON_ID
578: AND SUB_RELATIVE_LEVEL = 0
579: AND p_effective_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);