eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_TERMINATIONS dependencies on STANDARD

Line 29: ** 28-NOV-2001 nnaresh 115.12 Updated for GSCC Standards

25: ** 12-SEP-2001 shoskatt 115.11 Leave Initialise Values used for calculating the Accruals
26: ** Bug #1942971
27: ** Package containing addition processing required by
28: ** formula in AU localisatons.
29: ** 28-NOV-2001 nnaresh 115.12 Updated for GSCC Standards
30: ** 04-Dec-2002 Ragovind 115.13 Added NOCOPY to thr functions check_rollover, etp_prepost_ratios
31: ** ,get_long_service_leave, term_lsl_eligibility_years
32: ** 07-May-2003 Ragovind 115.15 Bug#2819479 - ETP Pre/Post Enhancement.
33: ** 18-May-2003 Ragovind 115.16 Added Reference Bug# for Bug#2819479

Line 378: (A) l_post93_accrual := Accrual (Standard Plan) + Accrual (FW Plan)

374: /* Bug 9950136 - Added changes for Foreign Worker
375: Assumption: All FW periods are after 01-Jul-2010. So It will affect only the Post 1993 Accruals
376:
377: Logic used:
378: (A) l_post93_accrual := Accrual (Standard Plan) + Accrual (FW Plan)
379: => [ get_accrual(Standard Plan) - get_accrual(Standard Plan in FW periods) ] + get_accrual(FW Plan)
380: => get_accrual(Standard Plan)
381:
382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]

Line 379: => [ get_accrual(Standard Plan) - get_accrual(Standard Plan in FW periods) ] + get_accrual(FW Plan)

375: Assumption: All FW periods are after 01-Jul-2010. So It will affect only the Post 1993 Accruals
376:
377: Logic used:
378: (A) l_post93_accrual := Accrual (Standard Plan) + Accrual (FW Plan)
379: => [ get_accrual(Standard Plan) - get_accrual(Standard Plan in FW periods) ] + get_accrual(FW Plan)
380: => get_accrual(Standard Plan)
381:
382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]
383: Accrual will not be fetched for Foreign Plan seperately because the of the above calculations. The FW Plan

Line 380: => get_accrual(Standard Plan)

376:
377: Logic used:
378: (A) l_post93_accrual := Accrual (Standard Plan) + Accrual (FW Plan)
379: => [ get_accrual(Standard Plan) - get_accrual(Standard Plan in FW periods) ] + get_accrual(FW Plan)
380: => get_accrual(Standard Plan)
381:
382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]
383: Accrual will not be fetched for Foreign Plan seperately because the of the above calculations. The FW Plan
384: eventually contributes to 0 always.

Line 382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]

378: (A) l_post93_accrual := Accrual (Standard Plan) + Accrual (FW Plan)
379: => [ get_accrual(Standard Plan) - get_accrual(Standard Plan in FW periods) ] + get_accrual(FW Plan)
380: => get_accrual(Standard Plan)
381:
382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]
383: Accrual will not be fetched for Foreign Plan seperately because the of the above calculations. The FW Plan
384: eventually contributes to 0 always.
385: (B) l_others_entitlement_post93 = Other Contrib (Standard Plan) + Other Contrib ( Foreign Plan)
386: (C) l_post93_absence = Absence (Standard Plan) + Other Contrib (Foreign Plan)

Line 385: (B) l_others_entitlement_post93 = Other Contrib (Standard Plan) + Other Contrib ( Foreign Plan)

381:
382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]
383: Accrual will not be fetched for Foreign Plan seperately because the of the above calculations. The FW Plan
384: eventually contributes to 0 always.
385: (B) l_others_entitlement_post93 = Other Contrib (Standard Plan) + Other Contrib ( Foreign Plan)
386: (C) l_post93_absence = Absence (Standard Plan) + Other Contrib (Foreign Plan)
387:
388: */
389:

Line 386: (C) l_post93_absence = Absence (Standard Plan) + Other Contrib (Foreign Plan)

382: [Since setup is mirrored get_accrual(Standard Plan in FW periods) = get_accrual(FW Plan)]
383: Accrual will not be fetched for Foreign Plan seperately because the of the above calculations. The FW Plan
384: eventually contributes to 0 always.
385: (B) l_others_entitlement_post93 = Other Contrib (Standard Plan) + Other Contrib ( Foreign Plan)
386: (C) l_post93_absence = Absence (Standard Plan) + Other Contrib (Foreign Plan)
387:
388: */
389:
390: hr_au_holidays.set_accrual_ids(l_plan_id);

Line 692: Standard Plan Accrual ID

688: l_accrual_plan_id number ;
689: l_dummy number ;
690: --
691: /* Bug 9950136 - Modified cursor to pick the non-FW
692: Standard Plan Accrual ID
693: */
694: cursor csr_get_accrual_plan_id
695: (p_assignment_id number
696: ,p_effective_date date

Line 1357: p_earnings_standard out NOCOPY number, /Bug 4474896/

1353: p_hire_date in date,
1354: p_period_start_date in date,
1355: p_period_end_date in date,
1356: p_case out NOCOPY varchar2,
1357: p_earnings_standard out NOCOPY number, /*Bug 4474896*/
1358: p_pre_tax_spread out NOCOPY number, /*Bug 4474896*/
1359: p_pre_tax_fixed out NOCOPY number, /*Bug 4474896*/
1360: p_pre_tax_prog out NOCOPY number, /*Bug 4474896*/
1361: p_paid_periods out NOCOPY number, /*Bug 4474896*/

Line 1540: p_earnings_standard := 0; /Bug 4474896/

1536: BEGIN
1537:
1538: l_procedure := 'calculate_term_asg_nge';
1539: g_ytd_def_bals_populated := FALSE;
1540: p_earnings_standard := 0; /*Bug 4474896*/
1541: p_pre_tax_spread := 0; /*Bug 4474896*/
1542: p_pre_tax_fixed := 0; /*Bug 4474896*/
1543: p_pre_tax_prog := 0; /*Bug 4474896*/
1544: i := 1;

Line 1743: /Bug 4474896 - Modified the code to pick balances Earnings Standard, Pre Tax Spread, Pre Tax Progressive, Pre Tax Fixed/

1739: P_DEFINED_BALANCE_LST => g_ytd_input_table,
1740: P_CONTEXT_LST => g_ytd_context_table,
1741: P_OUTPUT_TABLE => g_ytd_result_table);
1742:
1743: /*Bug 4474896 - Modified the code to pick balances Earnings Standard, Pre Tax Spread, Pre Tax Progressive, Pre Tax Fixed*/
1744: FOR i in g_ytd_result_table.first .. g_ytd_result_table.last
1745: LOOP
1746: IF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'

Line 1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'

1743: /*Bug 4474896 - Modified the code to pick balances Earnings Standard, Pre Tax Spread, Pre Tax Progressive, Pre Tax Fixed*/
1744: FOR i in g_ytd_result_table.first .. g_ytd_result_table.last
1745: LOOP
1746: IF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'
1748: THEN
1749: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);
1750: IF g_debug THEN
1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);

Line 1749: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);

1745: LOOP
1746: IF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'
1748: THEN
1749: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);
1750: IF g_debug THEN
1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);
1752: END IF;
1753: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id

Line 1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);

1747: and g_ytd_bals(i).balance_name = 'Earnings_Standard'
1748: THEN
1749: p_earnings_standard := nvl(g_ytd_result_table(i).balance_value,0);
1750: IF g_debug THEN
1751: hr_utility.set_location('p_earnings_standard: '||p_earnings_standard, 60);
1752: END IF;
1753: ELSIF g_ytd_result_table(i).defined_balance_id = g_ytd_bals(i).defined_balance_id
1754: and g_ytd_bals(i).balance_name = 'Pre Tax Spread Deductions'
1755: THEN

Line 1792: p_earnings_standard := p_earnings_standard + l_leave_loading;

1788: END IF;
1789: END LOOP;
1790:
1791: IF to_char(l_eff_date,'dd/mm/yyyy') >= '01/07/2009' THEN /*bug8725341*/
1792: p_earnings_standard := p_earnings_standard + l_leave_loading;
1793: END IF;
1794:
1795: return 1000;
1796: END IF;

Line 3151: /* Count the Standard Accrual */

3147: l_hours_flag := NULL;
3148: l_days_flag := NULL;
3149:
3150:
3151: /* Count the Standard Accrual */
3152: FOR csr1 IN csr_get_accrual_plan_id(p_assignment_id, p_effective_date,l_abs_category,'N')
3153: LOOP
3154: IF (csr1.accrual_units_of_measure = 'H' AND l_days_flag='Y') OR (csr1.accrual_units_of_measure = 'D' AND l_hours_flag='Y')
3155: THEN

Line 3820: where pbt.balance_name in ('Earnings_Standard'

3816:
3817: cursor csr_get_balance_name is
3818: select pbt.balance_name
3819: from pay_balance_types pbt
3820: where pbt.balance_name in ('Earnings_Standard'
3821: ,'Earnings_Leave_Loading'
3822: ,'Earnings_Additional'
3823: ,'Earnings_Spread'
3824: ,'Leave Payments Marginal'