APPS.PAY_ELEMENT_TEMPLATE_UTIL dependencies on PAY_TEMPLATE_FF_USAGES

Line 546: , pay_template_ff_usages tfu

542: , f.formula_text
543: , f.formula_type_name
544: , f.object_version_number
545: from pay_shadow_formulas f
546: , pay_template_ff_usages tfu
547: where tfu.template_id = p_template_id
548: and f.formula_id = tfu.formula_id
549: for update of f.formula_id;
550: begin

Line 1073: from pay_template_ff_usages

1069: formula_id,
1070: object_id,
1071: object_version_number,
1072: exclusion_rule_id
1073: from pay_template_ff_usages
1074: where template_id = p_template_id
1075: for update of template_ff_usage_id;
1076: begin
1077: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3327: -- pay_template_ff_usages --

3323: where db.balance_type_id = bt.balance_type_id
3324: and bt.template_id = p_template_id
3325: );
3326: ----------------------------
3327: -- pay_template_ff_usages --
3328: ----------------------------
3329: delete from pay_template_ff_usages
3330: where template_id = p_template_id;
3331: ----------------------------------

Line 3329: delete from pay_template_ff_usages

3325: );
3326: ----------------------------
3327: -- pay_template_ff_usages --
3328: ----------------------------
3329: delete from pay_template_ff_usages
3330: where template_id = p_template_id;
3331: ----------------------------------
3332: -- pay_shadow_gu_bal_exclusions --
3333: ----------------------------------