APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_CITY_SCHOOL_DSTS

Line 1653: PAY_US_CITY_SCHOOL_DSTS.

1649: The name is being reteived from the School Dsts table
1650: depending on the following :
1651: - get the School District Name from PAY_US_COUNTY_SCHOOL_DSTS.
1652: - If not found then get the School District Name from
1653: PAY_US_CITY_SCHOOL_DSTS.
1654: If the School Dsts Code passed is not in the table then
1655: NULL is passed.
1656: ************************************************************/
1657: Function get_school_dsts_name

Line 1664: from pay_us_city_school_dsts pcisd

1660:
1661: Cursor c_city_school_dsts
1662: (cp_jurisdiction_code in varchar2) is
1663: select initcap(pcisd.school_dst_name)
1664: from pay_us_city_school_dsts pcisd
1665: where pcisd.state_code = substr(cp_jurisdiction_code,1,2)
1666: and pcisd.school_dst_code = substr(cp_jurisdiction_code,4);
1667:
1668: Cursor c_county_school_dsts