DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_BALANCE_PKG

Line 1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1015: l_high_range_factor pay_mx_earn_exemption_rules_f.high_range_factor%TYPE;
1016: l_high_range_basis pay_mx_earn_exemption_rules_f.high_range_basis%TYPE;
1017: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
1018: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
1019: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1020: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1021: ln_person_id per_all_people_f.person_id%TYPE;
1022: l_classification_id NUMBER;
1023: l_hire_date DATE;

Line 1470: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1466: AND ptp_prev.end_date);
1467:
1468: l_prev_assact pay_assignment_actions.assignment_action_id%TYPE;
1469: l_payroll_id pay_payroll_actions.payroll_id%TYPE;
1470: l_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1471: l_counter NUMBER;
1472: l_balance_value NUMBER;
1473: l_proc_name VARCHAR2(100);
1474:

Line 1492: pay_balance_pkg.get_value (

1488: l_counter := 1;
1489:
1490: l_balance_value_tab(l_counter).defined_balance_id := get_def_bal_id (p_mode);
1491: l_balance_value_tab(l_counter).balance_value := 0;
1492: pay_balance_pkg.get_value (
1493: p_assignment_action_id => l_prev_assact,
1494: p_defined_balance_lst => l_balance_value_tab,
1495: p_get_rr_route => FALSE,
1496: p_get_rb_route => FALSE);

Line 2115: ln_bal_ISR_non_wrkd_days := pay_balance_pkg.get_value(ln_def_bal_id,

2111: FETCH csr_def_bal_id INTO ln_def_bal_id;
2112: CLOSE csr_def_bal_id;
2113:
2114: hr_utility_trace('ISR Non Working Days def bal id '||to_char(ln_def_bal_id));
2115: ln_bal_ISR_non_wrkd_days := pay_balance_pkg.get_value(ln_def_bal_id,
2116: p_assignment_action_id,
2117: p_tax_unit_id,
2118: NULL,
2119: NULL,

Line 2312: ln_bal_amt := pay_balance_pkg.get_value(ln_def_bal_id,

2308: CLOSE csr_def_bal_id;
2309:
2310: hr_utility_trace('ISR Subject def bal id '||ln_def_bal_id);
2311:
2312: ln_bal_amt := pay_balance_pkg.get_value(ln_def_bal_id,
2313: P_ASSIGNMENT_ACTION_ID,
2314: p_tax_unit_id,
2315: NULL,
2316: NULL,

Line 2331: ln_ISR_subj_adj := pay_balance_pkg.get_value(ln_def_bal_id,

2327: FETCH csr_def_bal_id INTO ln_def_bal_id;
2328: CLOSE csr_def_bal_id;
2329:
2330: hr_utility_trace('ISR Subject Adjusted def bal id '||ln_def_bal_id);
2331: ln_ISR_subj_adj := pay_balance_pkg.get_value(ln_def_bal_id,
2332: P_ASSIGNMENT_ACTION_ID,
2333: p_tax_unit_id,
2334: null,
2335: null,

Line 2354: ln_bal_sub := pay_balance_pkg.get_value(ln_def_bal_id,

2350: CLOSE csr_def_bal_id;
2351:
2352: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
2353:
2354: ln_bal_sub := pay_balance_pkg.get_value(ln_def_bal_id,
2355: P_ASSIGNMENT_ACTION_ID,
2356: p_tax_unit_id,
2357: NULL,
2358: NULL,

Line 2373: ln_bal_sub_paid := pay_balance_pkg.get_value(ln_def_bal_id,

2369: CLOSE csr_def_bal_id;
2370:
2371: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
2372:
2373: ln_bal_sub_paid := pay_balance_pkg.get_value(ln_def_bal_id,
2374: P_ASSIGNMENT_ACTION_ID,
2375: p_tax_unit_id,
2376: NULL,
2377: NULL,

Line 2947: ln_bal_ISR_non_wrkd_days := pay_balance_pkg.get_value(ln_def_bal_id,

2943: FETCH csr_def_bal_id INTO ln_def_bal_id;
2944: CLOSE csr_def_bal_id;
2945:
2946: hr_utility_trace('ISR Non Working Days def bal id '||to_char(ln_def_bal_id));
2947: ln_bal_ISR_non_wrkd_days := pay_balance_pkg.get_value(ln_def_bal_id,
2948: p_assignment_action_id,
2949: p_tax_unit_id,
2950: NULL,
2951: NULL,

Line 3135: ln_bal_amt := pay_balance_pkg.get_value(ln_def_bal_id,

3131: CLOSE csr_def_bal_id;
3132:
3133: hr_utility_trace('ISR Subject def bal id '||ln_def_bal_id);
3134:
3135: ln_bal_amt := pay_balance_pkg.get_value(ln_def_bal_id,
3136: P_ASSIGNMENT_ACTION_ID,
3137: p_tax_unit_id,
3138: NULL,
3139: NULL,

Line 3154: ln_ISR_subj_adj := pay_balance_pkg.get_value(ln_def_bal_id,

3150: FETCH csr_def_bal_id INTO ln_def_bal_id;
3151: CLOSE csr_def_bal_id;
3152:
3153: hr_utility_trace('ISR Subject Adjusted def bal id '||ln_def_bal_id);
3154: ln_ISR_subj_adj := pay_balance_pkg.get_value(ln_def_bal_id,
3155: P_ASSIGNMENT_ACTION_ID,
3156: p_tax_unit_id,
3157: null,
3158: null,

Line 3177: ln_bal_sub := pay_balance_pkg.get_value(ln_def_bal_id,

3173: CLOSE csr_def_bal_id;
3174:
3175: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
3176:
3177: ln_bal_sub := pay_balance_pkg.get_value(ln_def_bal_id,
3178: P_ASSIGNMENT_ACTION_ID,
3179: p_tax_unit_id,
3180: NULL,
3181: NULL,

Line 3196: ln_bal_sub_paid := pay_balance_pkg.get_value(ln_def_bal_id,

3192: CLOSE csr_def_bal_id;
3193:
3194: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
3195:
3196: ln_bal_sub_paid := pay_balance_pkg.get_value(ln_def_bal_id,
3197: P_ASSIGNMENT_ACTION_ID,
3198: p_tax_unit_id,
3199: NULL,
3200: NULL,

Line 3420: ln_ISR_subj_adj_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3416: FETCH csr_def_bal_id INTO ln_def_bal_id;
3417: CLOSE csr_def_bal_id;
3418:
3419: hr_utility_trace('ISR Subject def bal id '||ln_def_bal_id);
3420: ln_ISR_subj_adj_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3421: P_ASSIGNMENT_ACTION_ID,
3422: p_tax_unit_id,
3423: null,
3424: null,

Line 3441: ln_ISR_calculated_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3437: FETCH csr_def_bal_id INTO ln_def_bal_id;
3438: CLOSE csr_def_bal_id;
3439:
3440: hr_utility_trace('ISR Calculated def bal id '||ln_def_bal_id);
3441: ln_ISR_calculated_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3442: P_ASSIGNMENT_ACTION_ID,
3443: p_tax_unit_id,
3444: null,
3445: null,

Line 3460: ln_ISR_withheld_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3456: CLOSE csr_def_bal_id;
3457:
3458: hr_utility_trace('ISR Withheld def bal id '||to_char(ln_def_bal_id));
3459:
3460: ln_ISR_withheld_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3461: P_ASSIGNMENT_ACTION_ID,
3462: p_tax_unit_id,
3463: NULL,
3464: NULL,

Line 3479: ln_ISR_subsidy_paid_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3475: CLOSE csr_def_bal_id;
3476:
3477: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
3478:
3479: ln_ISR_subsidy_paid_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3480: P_ASSIGNMENT_ACTION_ID,
3481: p_tax_unit_id,
3482: NULL,
3483: NULL,

Line 3500: ln_ISR_subsidy_empl_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3496: CLOSE csr_def_bal_id;
3497:
3498: hr_utility_trace('ISR Sub for Empl def bal id '||to_char(ln_def_bal_id));
3499:
3500: ln_ISR_subsidy_empl_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3501: P_ASSIGNMENT_ACTION_ID,
3502: p_tax_unit_id,
3503: NULL,
3504: NULL,

Line 3522: ln_bal_ISR_non_wrkd_days_ytd := pay_balance_pkg.get_value(ln_def_bal_id,

3518: FETCH csr_def_bal_id INTO ln_def_bal_id;
3519: CLOSE csr_def_bal_id;
3520:
3521: hr_utility_trace('ISR Non Working Days def bal id '||to_char(ln_def_bal_id));
3522: ln_bal_ISR_non_wrkd_days_ytd := pay_balance_pkg.get_value(ln_def_bal_id,
3523: p_assignment_action_id,
3524: p_tax_unit_id,
3525: NULL,
3526: NULL,

Line 3886: l_gross_earning:=pay_balance_pkg.get_value

3882: P_LEGISLATION_INFO5 => l_ignore,
3883: P_LEGISLATION_INFO6 => l_ignore
3884: );
3885:
3886: l_gross_earning:=pay_balance_pkg.get_value
3887: (p_defined_balance_id =>l_bal_defined_id,
3888: p_assignment_action_id =>l_assignment_action_id,
3889: p_tax_unit_id => NULL,
3890: p_jurisdiction_code => NULL,