[Home] [Help]
196: *** 11-Aug-06 hnainani 115.170 Bug#5395393 Modified the v_lst_year_start variable to be assigned to financial year start
197: *** instead of FBT year Start. This was done to keep it consistent with the
198: *** Archive_code procedure and End Of Year Reconciliation Reports.
199: *** 01-Sep-06 sclarke 115.172 Bug#4925547 Altered archive of allowances and unions to support 2006/2007 layout.
200: *** 05-Oct-06 priupadh 115.174 The file is now dual maintained ,R12 version will be in Sync.
201: *** 06-Oct-06 hnainani 115.179 Bug# 5377624 Modified cursor c_get_pay_Effective_date to link Time Period Id with Date_Earned
202: *** to get the assignment action id
203: ***
204: *** 10-Oct-06 abhargav 115.180 Bug#4925547 Added bug references for changes done under Bug#4925547.
1465: );
1466:
1467: cursor next_action_id is
1468: select pay_assignment_actions_s.nextval
1469: from dual;
1470:
1471: /* Bug 5708255 */
1472: -------------------------------------------
1473: -- Added cursor to get value of global FBT_THRESHOLD
3257: END get_foreign_leave_payments;
3258:
3259: ----------------------------------------------------------------------------
3260: /* Archive FW Details - bug9147430
3261: In addition to Individual eoy archiving, the procedure archives FW eoy values for each Foreign Worker status type
3262:
3263: Basic rule to produce FW payment summary is
3264: Total EOY balances including FW - FW EOY balances > 0
3265:
3842: FROM TABLE(t_union_bal_sort)
3843: ORDER BY balance_value desc)
3844: AS tab_au_eoy_bal_type)
3845: INTO t_union_bal_sort
3846: FROM dual;
3847:
3848: if g_debug then
3849: hr_utility.trace('FW Union after Sorting');
3850: for i in t_union_bal_sort.first .. t_union_bal_sort.last loop
4010: FROM TABLE(t_alw_bal_sort)
4011: ORDER BY balance_value desc)
4012: AS tab_au_eoy_bal_type)
4013: INTO t_alw_bal_sort
4014: FROM dual;
4015:
4016:
4017: for i in t_alw_bal_sort.first .. t_alw_bal_sort.last loop
4018: p_fw_alw_tab(i).balance_name := t_alw_bal_sort(i).balance_name;
4327: WHERE balance_value > 0
4328: ORDER BY balance_value desc)
4329: AS tab_au_eoy_bal_type)
4330: INTO t_alw_bal_sort
4331: FROM dual;
4332:
4333: hr_utility.trace('After FW Allowance Sorting');
4334: if t_alw_bal_sort.count >0 then -- bug10048508
4335: t_allowance_balance.delete;
4754: WHERE balance_value > 0
4755: ORDER BY balance_value desc)
4756: AS tab_au_eoy_bal_type)
4757: INTO t_union_bal_sort
4758: FROM dual;
4759:
4760: hr_utility.trace('After FW Union Sorting');
4761: if t_union_bal_sort.count >0 then -- bug10048508
4762: t_union_table.delete;
4798: -- 'Union Fees' legislative balance.
4799: -- This is mandatory setup so that all existing functionality is retained.
4800: --
4801: -- The 'new' method involves users 'linking' their union elements to an additional balance
4802: -- they have created. This enables the identification of values for the individual unions.
4803: -- The 'linking' involves creating a feed to the new balance and selecting that balance
4804: -- as the 'Union fees primary balance' in the Element DF.
4805: -- This setup is not mandatory
4806: --
9042: else -- Cases for negative FW status
9043:
9044: create_extract_archive_details(p_assignment_action_id
9045: ,'X_FW_PAYG_TYPE'
9046: ,l_payg_fw_type); -- default to have Individual Payment Summary only
9047:
9048: end if;
9049:
9050: --