DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on FND_USER

Line 3457: fnd_user

3453: IF G_USER_STATUS_RULE IS NULL
3454: THEN
3455: SELECT 1 INTO l_num
3456: FROM
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

Line 3458: ,fnd_user_resp_groups

3454: THEN
3455: SELECT 1 INTO l_num
3456: FROM
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

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;

Line 3462: AND fnd_user.user_id = fnd_user_resp_groups.user_id

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;
3466: RETURN TRUE;

Line 3463: AND fnd_user_resp_groups.responsibility_id = jtf_state_responsibilities.responsibility_id

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;
3466: RETURN TRUE;
3467: ELSE