eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on HR_DIRBAL

Line 295: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);

291: --Either SSP or SMP calculate should be true.
292: FOR I IN c_lat_assignment_actions
293: LOOP
294: IF L_CALCULATE_SSP THEN
295: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);
296: END IF;
297: IF L_CALCULATE_SMP THEN
298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);

Line 298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);

294: IF L_CALCULATE_SSP THEN
295: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);
296: END IF;
297: IF L_CALCULATE_SMP THEN
298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);

Line 299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);

295: l_ssp := l_ssp + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_ssp_id);
296: END IF;
297: IF L_CALCULATE_SMP THEN
298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);

Line 300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);

296: END IF;
297: IF L_CALCULATE_SMP THEN
298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
304: END IF;

Line 301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);

297: IF L_CALCULATE_SMP THEN
298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
304: END IF;
305: END LOOP;

Line 302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);

298: L_SMP := L_SMP + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SMP_ID);
299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
304: END IF;
305: END LOOP;
306: END IF;

Line 303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);

299: l_sap := l_sap + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_sap_id);
300: L_SPP_ADOPT := L_SPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_ADOPT_ID);
301: L_SPP_BIRTH := L_SPP_BIRTH + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_SPP_BIRTH_ID);
302: L_ASPP_ADOPT := L_ASPP_ADOPT + 100 * HR_DIRBAL.GET_BALANCE(I.lat_assignment_action_id,G_ASPP_ADOPT_ID);
303: l_aspp_birth := l_aspp_birth + 100 * hr_dirbal.get_balance(I.lat_assignment_action_id,g_aspp_birth_id);
304: END IF;
305: END LOOP;
306: END IF;
307: IF G_SSP_RECOVERY = 'Full' THEN

Line 513: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_smp_id);

509: OPEN get_defined_balance_id('SMP Total','_ASG_TRANSFER_PTD');
510: FETCH get_defined_balance_id INTO l_smp_id;
511: CLOSE get_defined_balance_id;
512:
513: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_smp_id);
514:
515: elsif l_element_name = 'Statutory Adoption Pay' then
516: OPEN get_defined_balance_id('SAP Total','_ASG_TRANSFER_PTD');
517: FETCH get_defined_balance_id INTO l_sap_id;

Line 520: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_sap_id);

516: OPEN get_defined_balance_id('SAP Total','_ASG_TRANSFER_PTD');
517: FETCH get_defined_balance_id INTO l_sap_id;
518: CLOSE get_defined_balance_id;
519:
520: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_sap_id);
521:
522: elsif l_element_name = 'Statutory Paternity Pay Adoption' then
523: OPEN get_defined_balance_id('SPP Adoption Total','_ASG_TRANSFER_PTD');
524: FETCH get_defined_balance_id INTO l_spp_adopt_id;

Line 526: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_spp_adopt_id);

522: elsif l_element_name = 'Statutory Paternity Pay Adoption' then
523: OPEN get_defined_balance_id('SPP Adoption Total','_ASG_TRANSFER_PTD');
524: FETCH get_defined_balance_id INTO l_spp_adopt_id;
525: CLOSE get_defined_balance_id;
526: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_spp_adopt_id);
527:
528: elsif l_element_name = 'Statutory Paternity Pay Birth' then
529: OPEN get_defined_balance_id('SPP Birth Total','_ASG_TRANSFER_PTD');
530: FETCH get_defined_balance_id INTO l_spp_birth_id;

Line 532: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_spp_birth_id);

528: elsif l_element_name = 'Statutory Paternity Pay Birth' then
529: OPEN get_defined_balance_id('SPP Birth Total','_ASG_TRANSFER_PTD');
530: FETCH get_defined_balance_id INTO l_spp_birth_id;
531: CLOSE get_defined_balance_id;
532: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_spp_birth_id);
533: elsif l_element_name = 'Additional Statutory Paternity Pay Adoption' then
534: OPEN get_defined_balance_id('ASPP Adoption Total','_ASG_TRANSFER_PTD');
535: FETCH get_defined_balance_id INTO l_aspp_adopt_id;
536: CLOSE get_defined_balance_id;

Line 537: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_aspp_adopt_id);

533: elsif l_element_name = 'Additional Statutory Paternity Pay Adoption' then
534: OPEN get_defined_balance_id('ASPP Adoption Total','_ASG_TRANSFER_PTD');
535: FETCH get_defined_balance_id INTO l_aspp_adopt_id;
536: CLOSE get_defined_balance_id;
537: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_aspp_adopt_id);
538: elsif l_element_name = 'Additional Statutory Paternity Pay Birth' then
539: OPEN get_defined_balance_id('ASPP Birth Total','_ASG_TRANSFER_PTD');
540: FETCH get_defined_balance_id INTO l_aspp_birth_id;
541: CLOSE get_defined_balance_id;

Line 542: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_aspp_birth_id);

538: elsif l_element_name = 'Additional Statutory Paternity Pay Birth' then
539: OPEN get_defined_balance_id('ASPP Birth Total','_ASG_TRANSFER_PTD');
540: FETCH get_defined_balance_id INTO l_aspp_birth_id;
541: CLOSE get_defined_balance_id;
542: p_nic_amount := l_nic_rate * hr_dirbal.get_balance(p_assignment_action_id ,l_aspp_birth_id);
543: else
544: p_nic_amount := l_nic_rate * p_amount;
545: END IF;
546: exception