APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_COUNTY_SCHOOL_DSTS

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

1059: The function gets the School District Name for the passed
1060: Jurisdiction Code.
1061: The name is being reteived from the School Dsts table
1062: depending on the following :
1063: - get the School District Name from PAY_US_COUNTY_SCHOOL_DSTS.
1064: - If not found then get the School District Name from
1065: PAY_US_CITY_SCHOOL_DSTS.
1066: If the School Dsts Code passed is not in the table then
1067: NULL is passed.

Line 1083: from pay_us_county_school_dsts pcosd

1079:
1080: Cursor c_county_school_dsts
1081: (cp_jurisdiction_code in varchar2) is
1082: select initcap(pcosd.school_dst_name)
1083: from pay_us_county_school_dsts pcosd
1084: where pcosd.state_code = substr(cp_jurisdiction_code,1,2)
1085: and pcosd.school_dst_code = substr(cp_jurisdiction_code,4);
1086:
1087: lv_school_dst_name varchar2(100);