APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on HRI_MDP_BDGTS_LBRCST_ORG_MV

Line 125: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV

121: '''||l_rateType||''') BUDGETED_AMOUNT,
122: null ACTUAL_AMOUNT,
123: null COMMITTED_AMOUNT,
124: null PREV_AVAILABLE
125: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV
126: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
127: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
128: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
129: GROUP BY ORGANIZATION_ID,

Line 158: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV bdg

154: RETURN NUMBER IS
155:
156: CURSOR prev_tot_budget IS
157: SELECT SUM(bdg.BUDGET_VALUE) budgeted_amount
158: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV bdg
159: WHERE bdg.ORGMGR_ID = p_ORGMGR_ID
160: AND bdg.EFFECTIVE_START_DATE <= p_effective_end_date
161: AND bdg.EFFECTIVE_END_DATE >= p_effective_start_date
162: AND bdg.organization_id = p_organization_id ;

Line 366: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV

362: null COMMITTED_AMOUNT,
363: null PREV_ACTUAL,
364: null PREV_COMMITED
365:
366: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV
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

Line 555: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV bdg

551: RETURN NUMBER IS
552:
553: CURSOR Budget IS
554: SELECT SUM(bdg.BUDGET_VALUE) budgeted_amount
555: FROM HRI_MDP_BDGTS_LBRCST_ORG_MV bdg
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