DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 198: ,pay_balance_dimensions pbd

194: CURSOR csr_get_bal_info(c_balance_name VARCHAR2
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

Line 2404: l_balance_dim_ptd pay_balance_dimensions.database_item_suffix%TYPE;

2400: l_lca_tax_paid_ytd NUMBER :=0;
2401: l_recalculation VARCHAR2(1) :='N';
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;

Line 2405: l_balance_dim_ytd pay_balance_dimensions.database_item_suffix%TYPE;

2401: l_recalculation VARCHAR2(1) :='N';
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