APPS.HRI_OLTP_PMV_LBRCST_ORGMGR dependencies on HRI_MDP_CMNTS_ACTLS_ORGMGR_CT

Line 636: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act

632:
633: CURSOR prev_tot_actual_cmmt IS
634: SELECT SUM(act.ACTUAL_VALUE),
635: SUM(act.COMMITMENT_VALUE)
636: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act
637: WHERE act.ORGMGR_ID = p_ORGMGR_ID
638: AND act.organization_id = decode(p_organization_id,0,act.ORGANIZATION_ID,p_organization_id)
639: AND act.position_id = p_position_id
640: AND act.EFFECTIVE_START_DATE <= p_effective_end_date

Line 763: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT

759: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
760: ,POSITION_ID
761: ),
762: '''||l_rateType||''') PREV_AVAILABLE
763: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT
764: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
765: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
766: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
767: AND ORGANIZATION_ID = decode(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)

Line 887: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act,

883: '''||l_currency||''',
884: &BIS_CURRENT_ASOF_DATE,
885: SUM(act.COMMITMENT_VALUE),
886: '''||l_rateType||''') committed_amount
887: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act,
888: PER_ALL_ASSIGNMENTS_F paa,
889: HRI_CL_PER_V paf,
890: HR_ALL_POSITIONS_F pos
891: WHERE act.ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H

Line 946: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act

942:
943: CURSOR prev_tot_actual_cmmt IS
944: SELECT SUM(act.ACTUAL_VALUE),
945: SUM(act.COMMITMENT_VALUE)
946: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act
947: WHERE act.ORGMGR_ID = p_ORGMGR_ID
948: AND act.ORGANIZATION_ID = decode(p_organization_id,0,act.ORGANIZATION_ID,p_organization_id)
949: AND act.POSITION_ID = decode(p_position_id,0,act.POSITION_ID,p_position_id)
950: AND act.ELEMENT_TYPE_ID = P_ELEMENT_TYPE_ID

Line 1072: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT

1068: ,&BIS_PREVIOUS_EFFECTIVE_END_DATE
1069: ,ELEMENT_TYPE_ID
1070: ) ,
1071: '''||l_rateType||''') PREV_AVAILABLE
1072: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT
1073: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
1074: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
1075: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
1076: AND ORGANIZATION_ID = decode(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)

Line 1142: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act

1138:
1139: CURSOR prev_tot_actual_cmmt IS
1140: SELECT SUM(act.ACTUAL_VALUE),
1141: SUM(act.COMMITMENT_VALUE)
1142: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT act
1143: WHERE act.ORGMGR_ID = p_ORGMGR_ID
1144: AND act.ORGANIZATION_ID = decode(p_organization_id,0,act.ORGANIZATION_ID,p_organization_id)
1145: AND act.POSITION_ID = decode(p_position_id,0,act.POSITION_ID,p_position_id)
1146: AND act.ELEMENT_TYPE_ID = decode(p_element_type_id,0,act.ELEMENT_TYPE_ID,p_element_type_id)

Line 1268: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT

1264: ,&HRI_P_CHAR3_GA
1265: ,COST_ALLOCATION_KEYFLEX_ID
1266: ) ,
1267: '''||l_rateType||''') PREV_AVAILABLE
1268: FROM HRI_MDP_CMNTS_ACTLS_ORGMGR_CT
1269: WHERE ORGMGR_ID = &HRI_PERSON+HRI_PER_USRDR_H
1270: AND EFFECTIVE_START_DATE <= &BIS_CURRENT_EFFECTIVE_END_DATE
1271: AND EFFECTIVE_END_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE
1272: AND ORGANIZATION_ID = DECODE(&HRI_P_CHAR2_GA,0,ORGANIZATION_ID,&HRI_P_CHAR2_GA)