DBA Data[Home] [Help]

APPS.OKS_AUTO_REMINDER dependencies on FND_RESPONSIBILITY

Line 355: FROM fnd_responsibility

351: p_resp_key VARCHAR2
352: )
353: IS
354: SELECT responsibility_id
355: FROM fnd_responsibility
356: WHERE responsibility_key = p_resp_key
357: AND SYSDATE BETWEEN NVL (start_date, SYSDATE)
358: AND NVL (end_date, SYSDATE);
359:

Line 2611: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;

2607: l_fnd_person_party_id fnd_user.person_party_id%TYPE;
2608: l_start_date fnd_user.start_date%TYPE;
2609: l_end_date fnd_user.end_date%TYPE;
2610: l_test_user PLS_INTEGER;
2611: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;
2612: l_security_grp_id fnd_security_groups.security_group_id%TYPE;
2613: l_return_value BOOLEAN;
2614: l_user_id fnd_user.user_id%TYPE;
2615: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;

Line 2669: FROM fnd_responsibility

2665: p_resp_key VARCHAR2
2666: )
2667: IS
2668: SELECT responsibility_id
2669: FROM fnd_responsibility
2670: WHERE responsibility_key = p_resp_key
2671: AND SYSDATE BETWEEN NVL (start_date, SYSDATE)
2672: AND NVL (end_date, SYSDATE);
2673: