DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_COMMON dependencies on JTF_STATE_RULES_B

Line 3459: ,jtf_state_rules_b

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
3463: AND fnd_user_resp_groups.responsibility_id = jtf_state_responsibilities.responsibility_id

Line 3464: AND jtf_state_responsibilities.rule_id = jtf_state_rules_b.rule_id;

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
3468: RETURN G_USER_STATUS_RULE;