DBA Data[Home] [Help]

APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on PER_PEOPLE_F

Line 32: fnd_responsibility d, fnd_security_groups e, per_people_f ppf

28: pa.effective_end_date l_effective_end_date,
29: b.application_id as resp_application_id,
30: d.responsibility_key, e.security_group_key
31: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
32: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
33: where pa.ASSIGNEE_ID = c.user_id
34: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
35: and pa.ASSIGNOR_ID = p_assignor_id
36: and b.language = userenv('LANG')

Line 53: fnd_responsibility d, fnd_security_groups e, per_people_f ppf

49: pa.effective_end_date l_effective_end_date,
50: b.application_id as resp_application_id,
51: d.responsibility_key, e.security_group_key
52: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,
53: fnd_responsibility d, fnd_security_groups e, per_people_f ppf
54: where pa.ASSIGNEE_ID = c.user_id
55: and pa.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
56: and pa.ASSIGNOR_ID = p_assignor_id
57: and b.language = userenv('LANG')