[Home] [Help]
121: g_package constant varchar2(60) := 'pay_au_rec_det_paysum_mode.'; -- Global to store package name for tracing.
122: g_end_date date;
123: g_start_date date;
124: g_tax_unit_id pay_assignment_actions.tax_unit_id%type;
125: g_attribute_id pay_balance_attributes.attribute_id%type; -- bug 7571101
126: g_taxable_etp number; /* Start 9226023 - Global varaibles to store Taxable and Tax Free portions of ETP */
127: g_tax_free_etp number; /* End 9226023 */
128:
129: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */
2561: and not exists /* added for bug 7571001 */
2562: (
2563: select 1
2564: from
2565: PAY_BALANCE_ATTRIBUTES pba
2566: ,pay_defined_balances pdb
2567: ,pay_balance_dimensions pbd
2568: ,PAY_BALANCE_FEEDS_F pbf
2569: where pba.attribute_id = g_attribute_id
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf
2609: ,pay_defined_balances pdb
2610: ,pay_balance_dimensions pbd
2611: , pay_balance_attributes pba
2612: WHERE pba.attribute_id = g_attribute_id
2613: AND pdb.defined_balance_id = pba.defined_balance_id
2614: AND pbd.balance_dimension_id = pdb.balance_dimension_id
2615: AND pbd.dimension_name = '_ASG_LE_YTD'
2972: ,pay_balance_pkg.get_value(pdb.defined_balance_id
2973: ,p_run_assignment_action_id
2974: ,g_tax_unit_id
2975: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
2976: FROM pay_balance_attributes pba
2977: ,pay_defined_balances pdb
2978: ,pay_balance_types pbt
2979: ,pay_balance_dimensions pbd
2980: WHERE pba.attribute_id = g_attribute_id
2992: CURSOR c_get_fw_alw_bal_type_id IS
2993: select pbt.balance_type_id,
2994: pbt.balance_name
2995: from pay_bal_attribute_definitions pbad
2996: ,pay_balance_attributes pba
2997: ,pay_defined_balances pdb
2998: ,pay_balance_types pbt
2999: ,pay_balance_dimensions pbd
3000: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'