APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_US_CITY_SCHOOL_DSTS

Line 1065: PAY_US_CITY_SCHOOL_DSTS.

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.
1068: ************************************************************/
1069: Function get_school_dsts_name

Line 1076: from pay_us_city_school_dsts pcisd

1072:
1073: Cursor c_city_school_dsts
1074: (cp_jurisdiction_code in varchar2) is
1075: select initcap(pcisd.school_dst_name)
1076: from pay_us_city_school_dsts pcisd
1077: where pcisd.state_code = substr(cp_jurisdiction_code,1,2)
1078: and pcisd.school_dst_code = substr(cp_jurisdiction_code,4);
1079:
1080: Cursor c_county_school_dsts