eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2755: l_security_grp_id fnd_security_groups.security_group_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;
2759:

Line 2822: FROM fnd_security_groups

2818: p_security_grp_key VARCHAR2
2819: )
2820: IS
2821: SELECT security_group_id
2822: FROM fnd_security_groups
2823: WHERE security_group_key = p_security_grp_key;
2824:
2825: CURSOR csr_get_per_party_name (p_party_id IN NUMBER) IS
2826: SELECT party_name