DBA Data[Home] [Help]

APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on HR_ORGANIZATION_INFORMATION

Line 1192: FROM hr_organization_information hoi

1188:
1189:
1190: CURSOR c_check_psd_code_for_gre(psd_code varchar2, tax_unit_id number) IS
1191: SELECT 'Y'
1192: FROM hr_organization_information hoi
1193: WHERE hoi.organization_id = tax_unit_id AND
1194: hoi.org_information_context = 'PSD Reporting Rules' AND
1195: substr(hoi.org_information10,1,6)=psd_code;
1196: