17:
18: BEGIN
19:
20: if (not G_predicate_init or
21: G_user_id <> fnd_global.user_id or
22: G_resp_id <> fnd_global.resp_id) then
23:
24: fnd_profile.get('FA_SECURITY_PROFILE_ID', l_security_profile_id);
25:
18: BEGIN
19:
20: if (not G_predicate_init or
21: G_user_id <> fnd_global.user_id or
22: G_resp_id <> fnd_global.resp_id) then
23:
24: fnd_profile.get('FA_SECURITY_PROFILE_ID', l_security_profile_id);
25:
26: IF (l_security_profile_id is NULL) THEN
43:
44: END IF;
45:
46: G_predicate_init := TRUE;
47: G_user_id := fnd_global.user_id;
48: G_resp_id := fnd_global.resp_id;
49:
50: END IF;
51:
44: END IF;
45:
46: G_predicate_init := TRUE;
47: G_user_id := fnd_global.user_id;
48: G_resp_id := fnd_global.resp_id;
49:
50: END IF;
51:
52: return g_predicate_stmt;