APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_DEFINED_BALANCES

Line 199: ,pay_defined_balances pdb

195: ,c_database_item_suffix VARCHAR2) IS
196: SELECT pdb.defined_balance_id
197: FROM pay_balance_types pbt
198: ,pay_balance_dimensions pbd
199: ,pay_defined_balances pdb
200: WHERE pbt.balance_name = c_balance_name
201: AND pbt.legislation_code = 'NL'
202: AND pbd.database_item_suffix = c_database_item_suffix
203: AND pbd.legislation_code = 'NL'

Line 2406: l_lca_payments_bal_id pay_defined_balances.defined_balance_id%TYPE;

2402: l_start_date DATE;
2403: l_balance_name pay_balance_types.balance_name%TYPE := 'LCA Payments';
2404: l_balance_dim_ptd pay_balance_dimensions.database_item_suffix%TYPE;
2405: l_balance_dim_ytd pay_balance_dimensions.database_item_suffix%TYPE;
2406: l_lca_payments_bal_id pay_defined_balances.defined_balance_id%TYPE;
2407: l_action_info_id pay_action_information.action_information_id%TYPE;
2408: l_ovn pay_action_information.object_version_number%type;
2409: BEGIN
2410: hr_utility.set_location('Entering get_lca_details',1);