APPS.OKS_AUTO_REMINDER dependencies on FND_SECURITY_GROUPS

Line 365: FROM fnd_security_groups

361: p_security_grp_key VARCHAR2
362: )
363: IS
364: SELECT security_group_id
365: FROM fnd_security_groups
366: WHERE security_group_key = p_security_grp_key;
367:
368: -- modified cursor to always generate minimum length password
369: -- as defined by the Signon Password Length profile option.

Line 2612: l_security_grp_id fnd_security_groups.security_group_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;
2616:

Line 2679: FROM fnd_security_groups

2675: p_security_grp_key VARCHAR2
2676: )
2677: IS
2678: SELECT security_group_id
2679: FROM fnd_security_groups
2680: WHERE security_group_key = p_security_grp_key;
2681:
2682: CURSOR csr_get_per_party_name (p_party_id IN NUMBER) IS
2683: SELECT party_name