APPS.PAY_CA_WF_PKG dependencies on HR_CA_TAX_UNITS_V

Line 1428: from hr_ca_tax_units_v

1424: if p_gre_or_tax_group = 'GRE' then
1425: begin
1426: select name
1427: into lv_gre_name
1428: from hr_ca_tax_units_v
1429: where tax_unit_id = to_number(p_gre)
1430: and business_group_id = p_business_group_id
1431: and fnd_date.canonical_to_date(p_date_earned) between
1432: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));

Line 3564: from hr_ca_tax_units_v

3560: if p_gre_or_tax_group = 'GRE' then
3561: begin
3562: select name
3563: into lv_gre_name
3564: from hr_ca_tax_units_v
3565: where tax_unit_id = to_number(p_gre)
3566: and business_group_id = p_business_group_id
3567: and fnd_date.canonical_to_date(p_date_earned) between
3568: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));