DBA Data[Home] [Help]

APPS.HR_BALANCES dependencies on PAY_DEFINED_BALANCES

Line 37: PAY_DEFINED_BALANCES

33: PAY_SUB_CLASSIFICATION_RULES_F
34: PAY_BALANCE_FEEDS_F
35: PAY_BALANCE_TYPES
36: PAY_BALANCE_CLASSIFCIATIONS
37: PAY_DEFINED_BALANCES
38: --
39: Uses : hr_utility
40: Used By : n/a
41: --

Line 2051: from pay_defined_balances db

2047: --
2048: cursor get_def_bals(p_bal_type number)
2049: is
2050: select db.defined_balance_id
2051: from pay_defined_balances db
2052: where db.balance_type_id = p_bal_type;
2053: --
2054: BEGIN
2055: --

Line 2065: pay_defined_balances_pkg.chk_delete_defined_balance

2061: --
2062: -- call chk_delete_defined_balance, which will delete org_pay_methods,
2063: -- backpay rules, and balance attributes.
2064: --
2065: pay_defined_balances_pkg.chk_delete_defined_balance
2066: (each_def_bal.defined_balance_id);
2067: --
2068: DELETE FROM pay_defined_balances
2069: WHERE defined_balance_id = each_def_bal.defined_balance_id;

Line 2068: DELETE FROM pay_defined_balances

2064: --
2065: pay_defined_balances_pkg.chk_delete_defined_balance
2066: (each_def_bal.defined_balance_id);
2067: --
2068: DELETE FROM pay_defined_balances
2069: WHERE defined_balance_id = each_def_bal.defined_balance_id;
2070: --
2071: end loop;
2072: --