APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on HRI_MDP_CMNTS_ACTLS_ORG_MV

Line 108: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV

104: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
105: ,''AVAIL''
106: ),
107: '''||l_rateType||''') PREV_AVAILABLE
108: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV
109: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
110: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
111: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
112: GROUP BY ORGANIZATION_ID,

Line 167: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV act

163:
164: CURSOR prev_tot_actual_cmmt IS
165: SELECT SUM(act.ACTUAL_VALUE),
166: SUM(act.COMMITMENT_VALUE)
167: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV act
168: WHERE act.ORGMGR_ID = p_ORGMGR_ID
169: AND act.EFFECTIVE_START_DATE <= p_effective_end_date
170: AND act.EFFECTIVE_END_DATE >= p_effective_start_date
171: AND act.organization_id = p_organization_id;

Line 330: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV

326: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
327: ,''CMMT''
328: ) ,
329: '''||l_rateType||''') PREV_COMMITED
330: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV
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

Line 570: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV act

566:
567: CURSOR actls_cmnts IS
568: SELECT SUM(act.ACTUAL_VALUE),
569: SUM(act.COMMITMENT_VALUE)
570: FROM HRI_MDP_CMNTS_ACTLS_ORG_MV act
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