APPS.PAY_CA_YEPP_ADD_ACTIONS_PKG dependencies on PAY_CA_BALANCE_PKG

Line 666: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 Non Taxable Earnings',

662:
663: if p_report_type = 'T4' then
664:
665: ln_non_taxable_earnings :=
666: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 Non Taxable Earnings',
667: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
668: 0);
669:
670: hr_utility.trace('T4 Non Taxable Earnings :'||

Line 674: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',

670: hr_utility.trace('T4 Non Taxable Earnings :'||
671: to_char(ln_non_taxable_earnings));
672:
673: ln_gross_earnings :=
674: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',
675: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
676: 0);
677:
678: hr_utility.trace('Gross Earnings :'||

Line 682: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 No Gross Earnings',

678: hr_utility.trace('Gross Earnings :'||
679: to_char(ln_gross_earnings));
680:
681: ln_no_gross_earnings :=
682: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 No Gross Earnings',
683: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
684: 0);
685:
686: hr_utility.trace('T4 No Gross Earnings :'||

Line 723: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',

719:
720: elsif p_report_type = 'T4A' then
721:
722: ln_gross_earnings :=
723: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',
724: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
725: 0);
726:
727: hr_utility.trace('Gross Earnings :'||

Line 731: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4A No Gross Earnings',

727: hr_utility.trace('Gross Earnings :'||
728: to_char(ln_gross_earnings));
729:
730: ln_no_gross_earnings :=
731: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4A No Gross Earnings',
732: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
733: 0);
734:
735: hr_utility.trace('T4A No Gross Earnings :'||

Line 953: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

949:
950: if p_report_type = 'RL1' then
951:
952: ln_gross_earnings := ln_gross_earnings +
953: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
954: ('Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
955: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
956:
957: ln_no_gross_earnings := ln_no_gross_earnings +

Line 958: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

954: ('Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
955: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
956:
957: ln_no_gross_earnings := ln_no_gross_earnings +
958: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
959: ('RL1 No Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
960: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
961:
962: ln_non_taxable_earnings := ln_non_taxable_earnings +

Line 963: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

959: ('RL1 No Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
960: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
961:
962: ln_non_taxable_earnings := ln_non_taxable_earnings +
963: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
964: ('RL1 Non Taxable Earnings','YTD',l_bal_aaid,l_assignment_id,
965: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
966:
967: elsif p_report_type = 'RL2' then

Line 970: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

966:
967: elsif p_report_type = 'RL2' then
968:
969: ln_gross_earnings := ln_gross_earnings +
970: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
971: ('Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
972: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
973:
974: ln_no_gross_earnings := ln_no_gross_earnings +

Line 975: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

971: ('Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
972: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
973:
974: ln_no_gross_earnings := ln_no_gross_earnings +
975: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
976: ('RL2 No Gross Earnings','YTD',l_bal_aaid,l_assignment_id,
977: NULL,'PER',l_tax_unit_id,p_bus_grp,'QC'),0);
978:
979: end if; /* p_report_type */