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_MDP_BDGTS_LBRCST_ORGMGR_CT

Line 626: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg

622: RETURN NUMBER IS
623:
624: CURSOR prev_tot_budget IS
625: SELECT SUM(bdg.BUDGET_VALUE) budgeted_amount
626: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg
627: WHERE bdg.ORGMGR_ID = p_ORGMGR_ID
628: AND bdg.organization_id = decode(p_organization_id,0,bdg.ORGANIZATION_ID,p_organization_id)
629: AND bdg.position_id = p_position_id
630: AND bdg.EFFECTIVE_START_DATE <= p_effective_end_date

Line 781: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT

777: '''||l_rateType||''') BUDGETED_AMOUNT,
778: null ACTUAL_AMOUNT,
779: null COMMITTED_AMOUNT,
780: null PREV_AVAILABLE
781: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT
782: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
783: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
784: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
785: AND ORGANIZATION_ID = decode(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)

Line 934: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg

930: RETURN NUMBER IS
931:
932: CURSOR prev_tot_budget IS
933: SELECT SUM(bdg.BUDGET_VALUE) budgeted_amount
934: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg
935: WHERE bdg.ORGMGR_ID = p_ORGMGR_ID
936: AND bdg.ORGANIZATION_ID = decode(p_organization_id,0,bdg.ORGANIZATION_ID,p_organization_id)
937: AND bdg.POSITION_ID = decode(p_position_id,0,bdg.POSITION_ID,p_position_id)
938: AND bdg.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID

Line 1091: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT

1087: '''||l_rateType||''') BUDGETED_AMOUNT,
1088: null ACTUAL_AMOUNT,
1089: null COMMITTED_AMOUNT,
1090: null PREV_AVAILABLE
1091: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT
1092: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
1093: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
1094: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
1095: AND ORGANIZATION_ID = decode(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)

Line 1130: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg

1126: RETURN NUMBER IS
1127:
1128: CURSOR prev_tot_budget IS
1129: SELECT SUM(bdg.BUDGET_VALUE) budgeted_amount
1130: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT bdg
1131: WHERE bdg.ORGMGR_ID = p_ORGMGR_ID
1132: AND bdg.ORGANIZATION_ID = decode(p_organization_id,0,bdg.ORGANIZATION_ID,p_organization_id)
1133: AND bdg.POSITION_ID = decode(p_position_id,0,bdg.POSITION_ID,p_position_id)
1134: AND bdg.ELEMENT_TYPE_ID = decode(p_element_type_id,0,bdg.ELEMENT_TYPE_ID,p_element_type_id)

Line 1288: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT

1284: '''||l_rateType||''') BUDGETED_AMOUNT,
1285: null ACTUAL_AMOUNT,
1286: null COMMITTED_AMOUNT,
1287: null PREV_AVAILABLE
1288: FROM HRI_MDP_BDGTS_LBRCST_ORGMGR_CT
1289: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
1290: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
1291: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
1292: AND ORGANIZATION_ID = DECODE(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)