APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on PAY_ACCRUAL_PLANS

Line 444: update pay_accrual_plans set

440: hr_utility.set_location('Step '||g_package,950);
441:
442: IF p_accrual_category = 'FR_MAIN_HOLIDAY' Then
443: hr_utility.set_location('Step '||g_package,960);
444: update pay_accrual_plans set
445: information28 = l_input_value(3).input_value_id -- index 3 holds rate
446: ,information29 = l_input_value(2).input_value_id -- index 2 holds date
447: where accrual_plan_id = p_accrual_plan_id;
448:

Line 452: update pay_accrual_plans set

448:
449: ELSE
450: IF (p_accrual_category = 'FR_RTT_HOLIDAY') OR (p_accrual_category = 'FR_ADDITIONAL_HOLIDAY') Then
451: hr_utility.set_location('Step '||g_package,970);
452: update pay_accrual_plans set
453: information28 = l_input_value(3).input_value_id
454: ,information29 = l_input_value(2).input_value_id
455: where accrual_plan_id = p_accrual_plan_id;
456: END IF;

Line 864: update pay_accrual_plans set

860: --
861: --
862: IF p_accrual_category = 'FR_MAIN_HOLIDAY' Then
863: hr_utility.set_location('Step '||g_package,420);
864: update pay_accrual_plans set
865: information8 = input_value_table(3)
866: ,information9 = input_value_table(4)
867: ,information10 = input_value_table(5)
868: ,information11 = input_value_table(6)

Line 890: update pay_accrual_plans set

886:
887: ELSE
888: IF (p_accrual_category = 'FR_RTT_HOLIDAY') OR (p_accrual_category = 'FR_ADDITIONAL_HOLIDAY') Then
889: hr_utility.set_location('Step '||g_package,430);
890: update pay_accrual_plans set
891: information8 = input_value_table(3)
892: ,information13 = input_value_table(12)
893: ,information18 = input_value_table(21)
894: ,information23 = input_value_table(2)