384: FOR I IN c_lat_assignment_actions
385: LOOP
386: /* Commenting the code for SSP
387: IF L_CALCULATE_SSP THEN
388: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);
389: END IF;
390: */
391: IF L_CALCULATE_SMP THEN
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
388: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);
389: END IF;
390: */
391: IF L_CALCULATE_SMP THEN
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
389: END IF;
390: */
391: IF L_CALCULATE_SMP THEN
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
390: */
391: IF L_CALCULATE_SMP THEN
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
391: IF L_CALCULATE_SMP THEN
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
392: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
393: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
394: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
395: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
396: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
404: l_nic_aspp_birth := l_nic_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_aspp_birth_id);
397: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
404: l_nic_aspp_birth := l_nic_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_aspp_birth_id);
405: END IF;
398:
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
404: l_nic_aspp_birth := l_nic_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_aspp_birth_id);
405: END IF;
406: END LOOP;
399: L_nic_SMP := L_nic_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SMP_ID);
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
404: l_nic_aspp_birth := l_nic_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_aspp_birth_id);
405: END IF;
406: END LOOP;
407: END IF;
400: l_nic_sap := l_nic_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_sap_id);
401: L_nic_SPP_ADOPT := L_nic_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_ADOPT_ID);
402: L_nic_SPP_BIRTH := L_nic_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_SPP_BIRTH_ID);
403: L_nic_ASPP_ADOPT := L_nic_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_nic_ASPP_ADOPT_ID);
404: l_nic_aspp_birth := l_nic_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_nic_aspp_birth_id);
405: END IF;
406: END LOOP;
407: END IF;
408: /* Commenting the code for SSP