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_GB_RTI_P60 dependencies on PAY_BALANCE_PKG

Line 52: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances

48: g_per_agg_flag VARCHAR2(1);
49: g_ni_pt_eid NUMBER:=0;
50: g_ni_pt_ivid NUMBER:=0;
51: g_fps_bal_det_tab t_fps_bal_det_tab;
52: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
53: g_tax_ref VARCHAR2(20);
54: g_payroll_id NUMBER;
55: --
56: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;

Line 760: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

756:
757: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_p60_asg_det';
758: l_arch BOOLEAN;
759: l_asg_id number;
760: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
761: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
762: l_last_chld_act_id number;
763: l_tax_pay_def_bal_id number;
764: l_tax_pay_val number;

Line 761: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

757: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_p60_asg_det';
758: l_arch BOOLEAN;
759: l_asg_id number;
760: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
761: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
762: l_last_chld_act_id number;
763: l_tax_pay_def_bal_id number;
764: l_tax_pay_val number;
765: l_pay_previous number;

Line 957: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,

953: hr_utility.trace('l_tax_pay_val : '||l_tax_pay_val);
954: -- Test whether we can get run level value with parent action id.
955: -- If not pass the child assignment action id.
956: if l_tax_pay_val = 0 then
957: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
958: p_defined_balance_lst => g_defined_balance_lst ,
959: p_context_lst => l_context_lst ,
960: p_output_table => l_output_table );
961: else

Line 962: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,

958: p_defined_balance_lst => g_defined_balance_lst ,
959: p_context_lst => l_context_lst ,
960: p_output_table => l_output_table );
961: else
962: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
963: p_defined_balance_lst => g_defined_balance_lst ,
964: p_context_lst => l_context_lst ,
965: p_output_table => l_output_table );
966: end if;

Line 1082: pay_balance_pkg.get_value(p_assignment_action_id => l_aggr_last_chld_act_id,

1078: hr_utility.trace('l_tax_pay_val : '||l_tax_pay_val);
1079: -- Test whether we can get run level value with parent action id.
1080: -- If not pass the child assignment action id.
1081: if l_tax_pay_val = 0 then
1082: pay_balance_pkg.get_value(p_assignment_action_id => l_aggr_last_chld_act_id,
1083: p_defined_balance_lst => g_defined_balance_lst ,
1084: p_context_lst => l_context_lst ,
1085: p_output_table => l_output_table );
1086: else

Line 1087: pay_balance_pkg.get_value(p_assignment_action_id => l_aggr_last_asgact_id ,

1083: p_defined_balance_lst => g_defined_balance_lst ,
1084: p_context_lst => l_context_lst ,
1085: p_output_table => l_output_table );
1086: else
1087: pay_balance_pkg.get_value(p_assignment_action_id => l_aggr_last_asgact_id ,
1088: p_defined_balance_lst => g_defined_balance_lst ,
1089: p_context_lst => l_context_lst ,
1090: p_output_table => l_output_table );
1091: end if;

Line 3531: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);

3527: CLOSE csr_last_action;
3528:
3529: -- Fetching balances
3530: IF l_last_asg_action_id IS NOT NULL THEN
3531: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
3532: IF l_gross <= 0 THEN
3533: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
3534: END IF;
3535:

Line 3533: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);

3529: -- Fetching balances
3530: IF l_last_asg_action_id IS NOT NULL THEN
3531: l_gross := pay_balance_pkg.get_value(l_gross_id,l_last_asg_action_id);
3532: IF l_gross <= 0 THEN
3533: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
3534: END IF;
3535:
3536: IF l_taxable <= 0 THEN
3537: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

Line 3537: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);

3533: l_taxable := pay_balance_pkg.get_value(l_taxable_id,l_last_asg_action_id);
3534: END IF;
3535:
3536: IF l_taxable <= 0 THEN
3537: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
3538: end if;
3539:
3540: IF l_gross <= 0 THEN
3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);

Line 3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);

3537: l_niable := pay_balance_pkg.get_value(l_niable_id,l_last_asg_action_id);
3538: end if;
3539:
3540: IF l_gross <= 0 THEN
3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);
3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);

Line 3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);

3538: end if;
3539:
3540: IF l_gross <= 0 THEN
3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);
3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);

Line 3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);

3539:
3540: IF l_gross <= 0 THEN
3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);
3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);
3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);

Line 3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);

3540: IF l_gross <= 0 THEN
3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);
3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);
3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);
3548: END IF;

Line 3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);

3541: l_stud_loan := pay_balance_pkg.get_value(l_stud_loan_id,l_last_asg_action_id);
3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);
3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);
3548: END IF;
3549:

Line 3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);

3542: l_smp := pay_balance_pkg.get_value(l_smp_id,l_last_asg_action_id);
3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);
3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);
3548: END IF;
3549:
3550: END IF;

Line 3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);

3543: l_sap := pay_balance_pkg.get_value(l_sap_id,l_last_asg_action_id);
3544: l_spp_adopt := pay_balance_pkg.get_value(l_spp_adopt_id,l_last_asg_action_id);
3545: l_spp_birth := pay_balance_pkg.get_value(l_spp_birth_id,l_last_asg_action_id);
3546: l_aspp_adopt := pay_balance_pkg.get_value(l_aspp_adopt_id,l_last_asg_action_id);
3547: l_aspp_birth := pay_balance_pkg.get_value(l_aspp_birth_id,l_last_asg_action_id);
3548: END IF;
3549:
3550: END IF;
3551:

Line 4938: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);

4934: g_start_year,
4935: g_end_year);
4936: hr_utility.set_location('After Fetching Payroll Details ',10);
4937:
4938: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
4939:
4940: OPEN csr_is_etext_report;
4941: FETCH csr_is_etext_report INTO l_is_etext_report;
4942: CLOSE csr_is_etext_report;