DBA Data[Home] [Help]

APPS.IGS_SC_GRANTS_PVT dependencies on IGS_SC_OBJECTS

Line 67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,

63:
64:
65:
66: TYPE g_object_rec IS RECORD
67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,
68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,

Line 68: object_id igs_sc_objects.object_id%TYPE,

64:
65:
66: TYPE g_object_rec IS RECORD
67: ( obj_group_id igs_sc_objects.obj_group_id%TYPE,
68: object_id igs_sc_objects.object_id%TYPE,
69: table_name fnd_objects.database_object_name%TYPE,
70: default_policy_type igs_sc_obj_groups.default_policy_type%TYPE,
71: pk1_column_name fnd_objects.pk1_column_name%TYPE,
72: pk2_column_name fnd_objects.pk2_column_name%TYPE,

Line 390: FROM igs_sc_objects sco,

386: pk2_column_type ,
387: pk3_column_type ,
388: pk4_column_type ,
389: pk5_column_type
390: FROM igs_sc_objects sco,
391: fnd_objects fnd,
392: igs_sc_grants grn,
393: igs_sc_obj_groups grp
394: WHERE (application_id IN (8405,8406))

Line 1232: FROM igs_sc_objects sco,

1228: pk2_column_type ,
1229: pk3_column_type ,
1230: pk4_column_type ,
1231: pk5_column_type
1232: FROM igs_sc_objects sco,
1233: fnd_objects fnd,
1234: igs_sc_obj_groups grp
1235: WHERE application_id IN (8405,8406)
1236: AND fnd.obj_name = cp_obj_name