APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_COUNTY_SCHOOL_DSTS

Line 1651: - get the School District Name from PAY_US_COUNTY_SCHOOL_DSTS.

1647: The function gets the School District Name for the passed
1648: Jurisdiction Code.
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.

Line 1671: from pay_us_county_school_dsts pcosd

1667:
1668: Cursor c_county_school_dsts
1669: (cp_jurisdiction_code in varchar2) is
1670: select initcap(pcosd.school_dst_name)
1671: from pay_us_county_school_dsts pcosd
1672: where pcosd.state_code = substr(cp_jurisdiction_code,1,2)
1673: and pcosd.school_dst_code = substr(cp_jurisdiction_code,4);
1674:
1675: lv_school_dst_name varchar2(100);