[Home] [Help]
4106: AS
4107: /* Cursor replicates RR Route for _ASG_LE_YTD with status = 'B' check added */
4108: CURSOR get_retro_ytd_results(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
4109: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE
4110: ,c_balance_type_id pay_balance_types.balance_type_id%TYPE
4111: )
4112: IS
4113: SELECT SUM(NVL(TARGET.result_value,0))
4114: FROM
4137: CURSOR c_get_balance_details
4138: IS
4139: SELECT PBT.balance_name
4140: ,PBT.balance_type_id
4141: FROM pay_balance_types PBT
4142: WHERE PBT.balance_name IN ('Retro Earnings Leave Loading LT 12 Mths Prev Yr Amount'
4143: ,'Retro Earnings Leave Loading GT 12 Mths Amount')
4144: AND PBT.legislation_code ='AU';
4145:
4353: and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
4354: and paa.action_status='C'
4355: AND paa.tax_unit_id = TAX_UNIT_ID;
4356:
4357: CURSOR get_def_bal_id (p_bal_name IN pay_balance_types.balance_name%TYPE)
4358: IS
4359: select pdb.defined_balance_id defined_balance_id
4360: from pay_balance_types pbt
4361: , pay_balance_dimensions pbd
4356:
4357: CURSOR get_def_bal_id (p_bal_name IN pay_balance_types.balance_name%TYPE)
4358: IS
4359: select pdb.defined_balance_id defined_balance_id
4360: from pay_balance_types pbt
4361: , pay_balance_dimensions pbd
4362: , pay_defined_balances pdb
4363: where pbt.balance_name = p_bal_name
4364: and pbd.database_item_suffix = '_ASG_LE_PTD'
4389: , 'Foreign Leave Payments Marginal',20
4390: , 'Foreign Lump Sum A Payments',21
4391: ) sort_index,
4392: pdb.defined_balance_id def_bal_id
4393: FROM pay_balance_types pbt,
4394: pay_defined_balances pdb,
4395: pay_balance_dimensions pbd
4396: WHERE pbt.legislation_code = 'AU'
4397: AND pdb.balance_type_id = pbt.balance_type_id