APPS.IGS_PE_GEN_002 dependencies on PER_ALL_ASSIGNMENTS_F

Line 844: SELECT 'Y' FROM PER_ALL_ASSIGNMENTS_F WHERE assignment_id > 1 AND ROWNUM = 1;

840: WHERE APPLICATION_ID = 800;
841:
842: -- ssawhney for perf reasons, using pk>1 rather than rownum
843: CURSOR hr_record IS
844: SELECT 'Y' FROM PER_ALL_ASSIGNMENTS_F WHERE assignment_id > 1 AND ROWNUM = 1;
845:
846: l_status FND_PRODUCT_INSTALLATIONS.STATUS%TYPE;
847: l_var VARCHAR2(1);
848: BEGIN