APPS.IGS_SC_GEN_001 dependencies on FND_OBJECTS

Line 168: fnd_objects fnd,

164: obj.obj_group_id ,
165: gr.grant_text
166: FROM igs_sc_grants gr,
167: igs_sc_objects obj,
168: fnd_objects fnd,
169: wf_local_user_roles rls
170: WHERE gr.grant_insert_flag='Y'
171: AND gr.locked_flag ='Y'
172: AND obj.obj_group_id = gr.obj_group_id

Line 217: fnd_objects c

213: IS
214: SELECT b.DEFAULT_POLICY_TYPE
215: FROM igs_sc_objects a,
216: igs_sc_obj_groups b,
217: fnd_objects c
218: WHERE c.obj_name = p_obj_name
219: AND c.object_id = a.object_id
220: AND b.obj_group_id = a.obj_group_id;
221:

Line 1007: l_obj_exists_cur := 'SELECT 1 FROM IGS_SC_OBJECTS SC, FND_OBJECTS FND WHERE SC.OBJECT_ID = FND.OBJECT_ID AND FND.OBJ_NAME = UPPER(:P_Tab_Name) AND ';

1003: END IF;
1004:
1005: IF P_Tab_Name <> 'IGS_PS_UNIT_OFR_OPT_SV' THEN
1006: --validate whether the table is registered for the particular operation or not.
1007: l_obj_exists_cur := 'SELECT 1 FROM IGS_SC_OBJECTS SC, FND_OBJECTS FND WHERE SC.OBJECT_ID = FND.OBJECT_ID AND FND.OBJ_NAME = UPPER(:P_Tab_Name) AND ';
1008: IF P_ACTION = 'S' THEN
1009: L_OBJ_EXISTS_CUR := L_OBJ_EXISTS_CUR||' SC.SELECT_FLAG = ''Y''';
1010: l_operation := 'SELECT';
1011: ELSIF P_ACTION = 'U' THEN