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 2393: from pay_element_types_f

2389: hr_utility.set_location(l_proc, 50);
2390:
2391: select processing_priority + 1
2392: into l_priority
2393: from pay_element_types_f
2394: where element_type_id = l_plan_rec.accrual_plan_element_type_id;
2395:
2396: hr_utility.trace('l_priority: '||to_char(l_priority));
2397:

Line 2515: from pay_element_types_f

2511: -- element.
2512: --
2513: select processing_priority
2514: into l_priority
2515: from pay_element_types_f
2516: where element_type_id = l_plan_rec.accrual_plan_element_type_id;
2517:
2518: hr_utility.trace('l_priority: '||to_char(l_priority));
2519:

Line 3193: delete from pay_element_types_f

3189: l_effective_end_date,
3190: '');
3191:
3192: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',44);
3193: delete from pay_element_types_f
3194: where element_type_id = p_accrual_plan_element_type_id;
3195:
3196: --
3197: -- ...then the carried over element type...

Line 3222: delete from pay_element_types_f

3218:
3219: --
3220: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',47);
3221: hr_utility.trace('DELETE ELEMENT: '||to_char(p_co_element_type_id));
3222: delete from pay_element_types_f
3223: where element_type_id = p_co_element_type_id;
3224:
3225: --
3226: -- ...then the residual element type.

Line 3249: delete from pay_element_types_f

3245: l_effective_end_date,
3246: '');
3247:
3248: --
3249: delete from pay_element_types_f
3250: where element_type_id = p_residual_element_type_id;
3251:
3252:
3253: --

Line 3277: delete from pay_element_types_f

3273: l_effective_end_date,
3274: '');
3275:
3276: --
3277: delete from pay_element_types_f
3278: where element_type_id = p_balance_element_type_id;
3279:
3280: --
3281: -- ...then the tagging element type.

Line 3304: delete from pay_element_types_f

3300: l_effective_end_date,
3301: '');
3302:
3303: --
3304: delete from pay_element_types_f
3305: where element_type_id = p_tagging_element_type_id;
3306:
3307: --
3308: -- Finally, delete the accrual plan record itself