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

Line 1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);

1476: --
1477: --
1478: -- Set balance contexts.
1479: --
1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1484: --

Line 1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1477: --
1478: -- Set balance contexts.
1479: --
1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1484: --
1485: --

Line 1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);

1478: -- Set balance contexts.
1479: --
1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1484: --
1485: --
1486: -- Reset the values to Zero: changes 2007/2008

Line 1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);

1479: --
1480: pay_balance_pkg.set_context('TAX_UNIT_ID', l_rec1.legal_employer_id);
1481: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1482: pay_balance_pkg.set_context('LOCAL_UNIT_ID', l_rec2.local_unit_id);
1483: pay_balance_pkg.set_context('JURISDICTION_CODE', l_rec2.tax_municipality_id);
1484: --
1485: --
1486: -- Reset the values to Zero: changes 2007/2008
1487: l_reimb_bse := 0;

Line 1546: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);

1542: -- Employer Contribution Special Percentage_TU_LU_YTD
1543: -- Employer Contribution Special_TU_LU_YTD
1544: --
1545: --
1546: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);
1547: l_le_si_bal_table(l_le_si_count).tax := l_le_si_bal_table(l_le_si_count).tax + l_bal_value;
1548: --
1549: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1550: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;

Line 1549: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);

1545: --
1546: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_tax_defbal_id, p_assignment_action_id => l_asg_act_id);
1547: l_le_si_bal_table(l_le_si_count).tax := l_le_si_bal_table(l_le_si_count).tax + l_bal_value;
1548: --
1549: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1550: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;
1551: --
1552: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1553: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;

Line 1552: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);

1548: --
1549: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1550: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct_base + l_bal_value;
1551: --
1552: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1553: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;
1554: --
1555: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);
1556: l_le_si_bal_table(l_le_si_count).emp_contr_spcl := l_le_si_bal_table(l_le_si_count).emp_contr_spcl + l_bal_value;

Line 1555: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);

1551: --
1552: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_pct_defbal_id, p_assignment_action_id => l_asg_act_id);
1553: l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct := l_le_si_bal_table(l_le_si_count).emp_contr_spcl_pct + l_bal_value;
1554: --
1555: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_defbal_id, p_assignment_action_id => l_asg_act_id);
1556: l_le_si_bal_table(l_le_si_count).emp_contr_spcl := l_le_si_bal_table(l_le_si_count).emp_contr_spcl + l_bal_value;
1557: --
1558:
1559: END IF;

Line 1563: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_reimb_bse_defbal_id, p_assignment_action_id => l_asg_act_id);

1559: END IF;
1560: --
1561: -- Start changes 2007/2008
1562: -- Special Reimburesd Base for US/Canada
1563: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_spcl_reimb_bse_defbal_id, p_assignment_action_id => l_asg_act_id);
1564: l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base := l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base + l_bal_value;
1565: --
1566: -- Employer Contribution Base
1567: --

Line 1568: l_emp_contr_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);

1564: l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base := l_le_si_bal_table(l_le_si_count).emp_contr_reimb_spcl_base + l_bal_value;
1565: --
1566: -- Employer Contribution Base
1567: --
1568: l_emp_contr_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);
1569: l_tot_emp_contr_bse := nvl(l_tot_emp_contr_bse,0) + nvl(l_emp_contr_bse,0);
1570: --
1571: -- Reimbursed Base
1572: --

Line 1573: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id

1569: l_tot_emp_contr_bse := nvl(l_tot_emp_contr_bse,0) + nvl(l_emp_contr_bse,0);
1570: --
1571: -- Reimbursed Base
1572: --
1573: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1574: ,p_assignment_action_id => l_asg_act_id);
1575: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1576: ,p_assignment_action_id => l_asg_act_id),0);
1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id

Line 1575: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id

1571: -- Reimbursed Base
1572: --
1573: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1574: ,p_assignment_action_id => l_asg_act_id);
1575: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1576: ,p_assignment_action_id => l_asg_act_id),0);
1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1578: ,p_assignment_action_id => l_asg_act_id),0);
1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id

Line 1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id

1573: l_reimb_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_sick_reimb_defbal_id
1574: ,p_assignment_action_id => l_asg_act_id);
1575: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1576: ,p_assignment_action_id => l_asg_act_id),0);
1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1578: ,p_assignment_action_id => l_asg_act_id),0);
1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1580: ,p_assignment_action_id => l_asg_act_id),0);
1581: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id

Line 1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id

1575: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_child_mind_reimb_defbal_id
1576: ,p_assignment_action_id => l_asg_act_id),0);
1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1578: ,p_assignment_action_id => l_asg_act_id),0);
1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1580: ,p_assignment_action_id => l_asg_act_id),0);
1581: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1582: ,p_assignment_action_id => l_asg_act_id),0);
1583: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id

Line 1581: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id

1577: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_parent_reimb_defbal_id
1578: ,p_assignment_action_id => l_asg_act_id),0);
1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1580: ,p_assignment_action_id => l_asg_act_id),0);
1581: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1582: ,p_assignment_action_id => l_asg_act_id),0);
1583: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id
1584: ,p_assignment_action_id => l_asg_act_id),0);
1585: -- Total of the Reimbursed bases for all the zones

Line 1583: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id

1579: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_sick_hdy_reimb_defbal_id
1580: ,p_assignment_action_id => l_asg_act_id),0);
1581: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_cld_sck_hdy_defbal_id
1582: ,p_assignment_action_id => l_asg_act_id),0);
1583: l_reimb_bse := nvl(l_reimb_bse,0) + nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_prnt_hdy_reimb_defbal_id
1584: ,p_assignment_action_id => l_asg_act_id),0);
1585: -- Total of the Reimbursed bases for all the zones
1586: l_tot_reimb_bse := nvl(l_tot_reimb_bse,0) + nvl(l_reimb_bse,0);
1587: --

Line 1590: l_pension_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_emp_pension_bse_defbal_id , p_assignment_action_id => l_asg_act_id);

1586: l_tot_reimb_bse := nvl(l_tot_reimb_bse,0) + nvl(l_reimb_bse,0);
1587: --
1588: -- Pension Base
1589: --
1590: l_pension_bse := pay_balance_pkg.get_value(p_defined_balance_id => l_emp_pension_bse_defbal_id , p_assignment_action_id => l_asg_act_id);
1591:
1592: l_tot_pension_bse := nvl(l_tot_pension_bse,0) + nvl(l_pension_bse,0);
1593: --
1594: -- End 2007/2008 changes

Line 1633: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);

1629: -- Employer Contribution Over 62 Base_TU_MU_LU_YTD
1630: --
1631: -- and add them into correct NI Zone.
1632: --
1633: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_ec_defbal_id, p_assignment_action_id => l_asg_act_id);
1634: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) :=
1635: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) + l_bal_value;
1636: l_le_si_bal_table(l_le_si_count).emp_contr.total :=
1637: l_le_si_bal_table(l_le_si_count).emp_contr.total + l_bal_value;

Line 1639: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_eco62_defbal_id, p_assignment_action_id => l_asg_act_id);

1635: l_le_si_bal_table(l_le_si_count).emp_contr.ni_zone(l_rec2.ni_zone) + l_bal_value;
1636: l_le_si_bal_table(l_le_si_count).emp_contr.total :=
1637: l_le_si_bal_table(l_le_si_count).emp_contr.total + l_bal_value;
1638: --
1639: l_bal_value := pay_balance_pkg.get_value(p_defined_balance_id => l_eco62_defbal_id, p_assignment_action_id => l_asg_act_id);
1640: l_le_si_bal_table(l_le_si_count).emp_contr_over62.ni_zone(l_rec2.ni_zone) :=
1641: l_le_si_bal_table(l_le_si_count).emp_contr_over62.ni_zone(l_rec2.ni_zone) + l_bal_value;
1642: l_le_si_bal_table(l_le_si_count).emp_contr_over62.total :=
1643: l_le_si_bal_table(l_le_si_count).emp_contr_over62.total + l_bal_value;

Line 1907: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);

1903: OPEN csr_PER(l_asg_rec.person_id, l_asg_rec.effective_date);
1904: FETCH csr_PER INTO l_person_rec;
1905: CLOSE csr_PER;
1906: --
1907: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1909: --
1910: -- Seaman_PER_TU_YTD
1911: --

Line 1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

1904: FETCH csr_PER INTO l_person_rec;
1905: CLOSE csr_PER;
1906: --
1907: pay_balance_pkg.set_context('TAX_UNIT_ID', l_asg_rec.legal_employer_id);
1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1909: --
1910: -- Seaman_PER_TU_YTD
1911: --
1912: l_bal_value := pay_balance_pkg.get_value

Line 1912: l_bal_value := pay_balance_pkg.get_value

1908: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
1909: --
1910: -- Seaman_PER_TU_YTD
1911: --
1912: l_bal_value := pay_balance_pkg.get_value
1913: (p_defined_balance_id => l_seaman_defbal_id
1914: ,p_assignment_id => l_asg_rec.assignment_id
1915: ,p_virtual_date => least(g_report_date,l_asg_rec.effective_end_date));
1916: --

Line 2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);

2475: --
2476: --
2477: -- Setup balance contexts.
2478: --
2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);

Line 2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));

2476: --
2477: -- Setup balance contexts.
2478: --
2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2484: --

Line 2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);

2477: -- Setup balance contexts.
2478: --
2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2484: --
2485: --

Line 2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);

2478: --
2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2484: --
2485: --
2486: -- Loop through all balance based reporting codes.

Line 2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);

2479: pay_balance_pkg.set_context('TAX_UNIT_ID' , l_asg_act_rec.legal_employer_id);
2480: pay_balance_pkg.set_context('DATE_EARNED' , fnd_date.date_to_canonical(g_report_date));
2481: pay_balance_pkg.set_context('LOCAL_UNIT_ID' , l_asg_act_rec.local_unit_id);
2482: -- pay_balance_pkg.set_context('JURISDICTION_CODE', l_asg_act_rec.tax_municipality_id);
2483: pay_balance_pkg.set_context('SOURCE_TEXT2' , l_asg_act_rec.municipality_code);
2484: --
2485: --
2486: -- Loop through all balance based reporting codes.
2487: --

Line 2499: pay_balance_pkg.set_context('SOURCE_TEXT', l_bal_rec.reporting_code);

2495: --
2496: --
2497: -- Setup balance contexts NB. This is used for reporting codes using BAL_CODE_CTX.
2498: --
2499: pay_balance_pkg.set_context('SOURCE_TEXT', l_bal_rec.reporting_code);
2500: --fnd_file.put_line(fnd_file.log,'$$$ reporting_code: '||l_bal_rec.reporting_code);
2501: --
2502: --
2503: -- Get balance value.

Line 2509: l_amount := pay_balance_pkg.get_value

2505: --fnd_file.put_line(fnd_file.log,'$$$ l_bal_rec.defined_balance_id: '||l_bal_rec.defined_balance_id);
2506: --fnd_file.put_line(fnd_file.log,'$$$ l_asg_act_rec.assignment_id: '||l_asg_act_rec.assignment_id);
2507: --fnd_file.put_line(fnd_file.log,'$$$ g_report_date: '||g_report_date);
2508: IF l_bal_rec.defined_balance_id IS NOT NULL THEN
2509: l_amount := pay_balance_pkg.get_value
2510: (p_defined_balance_id => l_bal_rec.defined_balance_id
2511: ,p_assignment_id => l_asg_act_rec.assignment_id
2512: ,p_virtual_date => g_report_date);
2513: ELSE

Line 2798: l_amount := pay_balance_pkg.get_value

2794: --
2795: -- Get balance value.
2796: --
2797: IF l_bal_info_rec.defined_balance_id IS NOT NULL THEN
2798: l_amount := pay_balance_pkg.get_value
2799: (p_defined_balance_id => l_bal_info_rec.defined_balance_id
2800: ,p_assignment_id => l_asg_act_rec.assignment_id
2801: ,p_virtual_date => g_report_date);
2802: ELSE

Line 3468: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);

3464: --
3465: --
3466: -- Setup balance contexts.
3467: --
3468: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
3469: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
3470: --
3471: --
3472: -- Retrieve balance for:-

Line 3469: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));

3465: --
3466: -- Setup balance contexts.
3467: --
3468: pay_balance_pkg.set_context('TAX_UNIT_ID', l_per_blw_rep_limit_rec.legal_employer_id);
3469: pay_balance_pkg.set_context('DATE_EARNED', fnd_date.date_to_canonical(g_report_date));
3470: --
3471: --
3472: -- Retrieve balance for:-
3473: --

Line 3476: l_amount := pay_balance_pkg.get_value

3472: -- Retrieve balance for:-
3473: --
3474: -- Tax_PER_TU_YTD
3475: --
3476: l_amount := pay_balance_pkg.get_value
3477: (p_defined_balance_id => l_tax_defbal_id
3478: ,p_assignment_id => l_asg_act_rec.assignment_id
3479: ,p_virtual_date => g_report_date);
3480: --