DBA Data[Home] [Help]

APPS.PAY_PYNZ345_XMLP_PKG dependencies on HR_NZ_TAX_UNIT_V

Line 53: l_registered_employer hr_nz_tax_unit_v.name%type;

49: return hr_reports.get_business_group(p_business_group_id);
50: end;
51:
52: function CF_registered_employerFormula return VARCHAR2 is
53: l_registered_employer hr_nz_tax_unit_v.name%type;
54: cursor c_registered_employer is
55: select name
56: from hr_nz_tax_unit_v
57: where business_group_id = p_business_group_id

Line 56: from hr_nz_tax_unit_v

52: function CF_registered_employerFormula return VARCHAR2 is
53: l_registered_employer hr_nz_tax_unit_v.name%type;
54: cursor c_registered_employer is
55: select name
56: from hr_nz_tax_unit_v
57: where business_group_id = p_business_group_id
58: and tax_unit_id = p_registered_employer_id;
59: begin
60: open c_registered_employer;