DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_RS_GROUP_MEMBERS

Line 936: FROM jtf_rs_group_members

932: IS
933: CURSOR c_group_id (b_resource_id IN VARCHAR2)
934: IS
935: SELECT group_id resource_id
936: FROM jtf_rs_group_members
937: WHERE resource_id = b_resource_id
938: AND delete_flag <> 'Y';
939:
940: CURSOR c_team_id (b_resource_id IN VARCHAR2)

Line 2113: FROM jtf_rs_group_members gm

2109: UNION ALL
2110: SELECT gm.group_id resource_id
2111: , 'RS_GROUP' resource_type_code
2112: , 'N' group_calendar_flag
2113: FROM jtf_rs_group_members gm
2114: WHERE gm.resource_id = p_resource_id
2115: UNION ALL
2116: SELECT g.group_id resource_id
2117: , 'RS_GROUP' resource_type_code