DBA Data[Home] [Help]

APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_CA_EMP_TAX_INF

Line 728: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,

724: AND blt.balance_name IN ('Regular Earnings',
725: 'Supplemental Earnings for EI',
726: 'Taxable Benefits for EI')
727: AND blt.legislation_code = 'CA'
728: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
729: SYSDATE,SYSDATE, pya.effective_date, 'EIEXEMPT'),'N') = 'N';
730:
731: CURSOR csr_get_dp_total1(p_asg_id NUMBER,
732: p_gre NUMBER,

Line 884: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,

880: AND blt.balance_name IN ('Regular Earnings',
881: 'Supplemental Earnings for EI',
882: 'Taxable Benefits for EI')
883: AND blt.legislation_code = 'CA'
884: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
885: SYSDATE,SYSDATE, pya.effective_date, 'EIEXEMPT'),'N') = 'N';
886:
887: CURSOR csr_get_de_total(p_asg_id NUMBER,
888: p_gre NUMBER,

Line 1039: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,

1035: AND blt.balance_name IN ('Regular Earnings',
1036: 'Supplemental Earnings for EI',
1037: 'Taxable Benefits for EI')
1038: AND blt.legislation_code = 'CA'
1039: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
1040: SYSDATE, SYSDATE, pya.date_earned, 'EIEXEMPT'),'N') = 'N';
1041:
1042: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.get_ei_amount_totals';
1043: