DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_COMMON dependencies on FND_GLOBAL

Line 818: WHERE user_id = fnd_global.user_id;

814: CURSOR c_resource
815: IS
816: SELECT resource_id, 'RS_' || category
817: FROM jtf_rs_resource_extns
818: WHERE user_id = fnd_global.user_id;
819: BEGIN
820: OPEN c_resource;
821: FETCH c_resource INTO x_resource_id, x_resource_type;
822:

Line 5132: WHERE fnd_user.user_id = fnd_global.user_id

5128: ,fnd_user_resp_groups
5129: ,fnd_responsibility
5130: ,jtf_state_rules_b
5131: , jtf_state_responsibilities
5132: WHERE fnd_user.user_id = fnd_global.user_id
5133: AND fnd_user.user_id = fnd_user_resp_groups.user_id
5134: AND fnd_user_resp_groups.responsibility_id = jtf_state_responsibilities.responsibility_id
5135: AND jtf_state_responsibilities.rule_id = jtf_state_rules_b.rule_id;
5136: G_USER_STATUS_RULE := TRUE;