APPS.PA_ALLOC_COPY_RULE_PKG dependencies on PA_ALLOC_RESOURCES

Line 168: from pa_alloc_resources

164: -- , LAST_UPDATE_LOGIN
165: , TARGET_EXPND_TYPE
166: , OFFSET_EXPND_TYPE
167: , RESOURCE_PERCENTAGE
168: from pa_alloc_resources
169: where rule_id = p_rule_id
170: for update of member_type;
171: --Cursor to get the Rule ID
172: CURSOR C1 is Select pa_alloc_rules_s.nextval from sys.dual;

Line 416: PA_ALLOC_RESOURCES_PKG.INSERT_ROW (

412: If (RSR_REC.MEMBER_TYPE = 'S' And G_Alloc_Rbs_Valid_Flag = 'Y' )
413: Or
414: (RSR_REC.MEMBER_TYPE = 'B' And G_Basis_Rbs_Valid_Flag = 'Y' )
415: Then
416: PA_ALLOC_RESOURCES_PKG.INSERT_ROW (
417: G_ROWID ,
418: G_RULE_ID ,
419: RSR_REC.MEMBER_TYPE ,
420: RSR_REC.RESOURCE_LIST_MEMBER_ID ,