DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on FND_GLOBAL

Line 712: WHERE user_id = fnd_global.user_id;

708: CURSOR c_resource
709: IS
710: SELECT resource_id, 'RS_' || category
711: FROM jtf_rs_resource_extns
712: WHERE user_id = fnd_global.user_id;
713: BEGIN
714: OPEN c_resource;
715: FETCH c_resource INTO x_resource_id, x_resource_type;
716:

Line 3461: WHERE fnd_user.user_id = fnd_global.user_id

3457: fnd_user
3458: ,fnd_user_resp_groups
3459: ,jtf_state_rules_b
3460: , jtf_state_responsibilities
3461: WHERE fnd_user.user_id = fnd_global.user_id
3462: AND fnd_user.user_id = fnd_user_resp_groups.user_id
3463: AND fnd_user_resp_groups.responsibility_id = jtf_state_responsibilities.responsibility_id
3464: AND jtf_state_responsibilities.rule_id = jtf_state_rules_b.rule_id;
3465: G_USER_STATUS_RULE := TRUE;