[Home] [Help]
313: hr_utility.trace('Period Type: '||L_PERIOD_TYPE);
314: IF NVL(L_AGGREGATION,'N') ='N' THEN
315: FOR L_ASSIGNMENT_ACTIONS IN C_ASSIGNMENT_ACTION(P_ASSIGNMENT_ID)
316: LOOP
317: L_BALANCE_VALUE := L_BALANCE_VALUE+PAY_BALANCE_PKG.GET_VALUE ( P_DEFINED_BALANCE_ID =>L_DEFINED_BALANCE_ID ,P_ASSIGNMENT_ACTION_ID=>L_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID ,P_GET_RR_ROUTE => FALSE ,
318: P_GET_RB_ROUTE => FALSE) ;
319: END LOOP;
320: END IF;
321: IF NVL(L_AGGREGATION,'N') ='Y' THEN
322: FOR ALL_ASSGN IN C_ASSIGNMENTS_AGG(L_PERSON_ID)
323: LOOP
324: FOR V_ASSIGNMENT_ACTIONS IN C_ASSIGNMENT_ACTION(ALL_ASSGN.ASSIGNMENT_ID)
325: LOOP
326: L_BALANCE_VALUE := L_BALANCE_VALUE+PAY_BALANCE_PKG.GET_VALUE ( P_DEFINED_BALANCE_ID =>L_DEFINED_BALANCE_ID ,P_ASSIGNMENT_ACTION_ID=>V_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID ,P_GET_RR_ROUTE => FALSE ,
327: P_GET_RB_ROUTE => FALSE) ;
328: IF L_PERIOD_TYPE IS NULL THEN
329: OPEN C_AGGREGATION_CHECK(ALL_ASSGN.ASSIGNMENT_ID);
330: FETCH C_AGGREGATION_CHECK INTO L_AGGREGATION,L_MAIN_ENTRY;
1219: LOOP
1220: --Fetch Value from Balance
1221: HR_UTILITY.trace('Assignment Action : '||L_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID);
1222: L_BALANCE_FLAG :='Y';
1223: L_TOTAL_EARNINGS_VALUE:=L_TOTAL_EARNINGS_VALUE + PAY_BALANCE_PKG.GET_VALUE ( P_DEFINED_BALANCE_ID =>G_DEFINED_BALANCE_ID ,P_ASSIGNMENT_ACTION_ID=>L_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID ,P_GET_RR_ROUTE => FALSE ,
1224: P_GET_RB_ROUTE => FALSE) ;
1225: HR_UTILITY.trace('L_TOTAL_EARNINGS_VALUE Balance Value : '||L_TOTAL_EARNINGS_VALUE);
1226: IF (L_TIME_PERIOD_ID = L_ASSIGNMENT_ACTIONS.TIME_PERIOD_ID) THEN
1227: -- For multiple payroll runs in the same period this will avoid multiple calculations of missed elements