APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_ELEMENT_TYPES_F

Line 131: from pay_element_types_f

127: select least(effective_start_date),
128: greatest(effective_end_date)
129: into l_effective_start_date,
130: l_effective_end_date
131: from pay_element_types_f
132: where element_type_id = p_element_type_id;
133:
134: if p_recurring_flag = 'N' and
135: (p_uom_code like 'D%' or p_uom_code = 'C') then

Line 1374: from pay_element_types_f

1370: --
1371:
1372: select processing_priority
1373: into l_priority
1374: from pay_element_types_f
1375: where element_type_id = l_accrual_plan_element_type_id;
1376:
1377: hr_utility.trace('l_priority: '||to_char(l_priority));
1378:

Line 2401: from pay_element_types_f

2397: hr_utility.set_location(l_proc, 50);
2398:
2399: select processing_priority + 1
2400: into l_priority
2401: from pay_element_types_f
2402: where element_type_id = l_plan_rec.accrual_plan_element_type_id;
2403:
2404: hr_utility.trace('l_priority: '||to_char(l_priority));
2405:

Line 2523: from pay_element_types_f

2519: -- element.
2520: --
2521: select processing_priority
2522: into l_priority
2523: from pay_element_types_f
2524: where element_type_id = l_plan_rec.accrual_plan_element_type_id;
2525:
2526: hr_utility.trace('l_priority: '||to_char(l_priority));
2527:

Line 3209: delete from pay_element_types_f

3205: l_effective_end_date,
3206: '');
3207:
3208: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',44);
3209: delete from pay_element_types_f
3210: where element_type_id = p_accrual_plan_element_type_id;
3211:
3212: --
3213: -- ...then the carried over element type...

Line 3238: delete from pay_element_types_f

3234:
3235: --
3236: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',47);
3237: hr_utility.trace('DELETE ELEMENT: '||to_char(p_co_element_type_id));
3238: delete from pay_element_types_f
3239: where element_type_id = p_co_element_type_id;
3240:
3241: --
3242: -- ...then the residual element type.

Line 3265: delete from pay_element_types_f

3261: l_effective_end_date,
3262: '');
3263:
3264: --
3265: delete from pay_element_types_f
3266: where element_type_id = p_residual_element_type_id;
3267:
3268:
3269: --

Line 3293: delete from pay_element_types_f

3289: l_effective_end_date,
3290: '');
3291:
3292: --
3293: delete from pay_element_types_f
3294: where element_type_id = p_balance_element_type_id;
3295:
3296: --
3297: -- ...then the tagging element type.

Line 3320: delete from pay_element_types_f

3316: l_effective_end_date,
3317: '');
3318:
3319: --
3320: delete from pay_element_types_f
3321: where element_type_id = p_tagging_element_type_id;
3322:
3323: --
3324: -- Finally, delete the accrual plan record itself