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 2754: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;

2750: l_fnd_person_party_id fnd_user.person_party_id%TYPE;
2751: l_start_date fnd_user.start_date%TYPE;
2752: l_end_date fnd_user.end_date%TYPE;
2753: l_test_user PLS_INTEGER;
2754: l_responsibility_id fnd_responsibility_vl.responsibility_id%TYPE;
2755: l_security_grp_id fnd_security_groups.security_group_id%TYPE;
2756: l_return_value BOOLEAN;
2757: l_user_id fnd_user.user_id%TYPE;
2758: l_quote_to_contact_id oks_k_headers_b.quote_to_contact_id%TYPE;

Line 2812: FROM fnd_responsibility

2808: p_resp_key VARCHAR2
2809: )
2810: IS
2811: SELECT responsibility_id
2812: FROM fnd_responsibility
2813: WHERE responsibility_key = p_resp_key
2814: AND SYSDATE BETWEEN NVL (start_date, SYSDATE)
2815: AND NVL (end_date, SYSDATE);
2816: