APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_CA_EMP_TAX_INF

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

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

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

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

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

1040: AND blt.balance_name IN ('Regular Earnings',
1041: 'Supplemental Earnings for EI',
1042: 'Taxable Benefits for EI')
1043: AND blt.legislation_code = 'CA'
1044: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
1045: SYSDATE, SYSDATE, pya.date_earned, 'EIEXEMPT'),'N') = 'N';
1046:
1047: CURSOR csr_get_de_total1(p_asg_id NUMBER,
1048: p_gre NUMBER,

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

1195: AND blt.balance_name IN ('Regular Earnings',
1196: 'Supplemental Earnings for EI',
1197: 'Taxable Benefits for EI')
1198: AND blt.legislation_code = 'CA'
1199: AND NVL(pay_ca_emp_tax_inf.get_tax_detail_char(p_asg_id,
1200: SYSDATE, SYSDATE, pya.date_earned, 'EIEXEMPT'),'N') = 'N';
1201:
1202: l_proc_name VARCHAR2(60) := 'pay_ca_roe_ei_pkg.get_ei_amount_totals';
1203: