APPS.IGS_PE_GEN_002 dependencies on FND_PRODUCT_INSTALLATIONS

Line 839: FND_PRODUCT_INSTALLATIONS

835: ssawhney 17 Aug 3690580, for perf reasons changed cursor hr_record.
836: ***************************************************************/
837: CURSOR hr_status IS
838: SELECT STATUS FROM
839: FND_PRODUCT_INSTALLATIONS
840: WHERE APPLICATION_ID = 800;
841:
842: -- ssawhney for perf reasons, using pk>1 rather than rownum
843: CURSOR hr_record IS

Line 846: l_status FND_PRODUCT_INSTALLATIONS.STATUS%TYPE;

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
849:
850: OPEN hr_status;