APPS.AP_WEB_PROXY_ASSIGN_PKG dependencies on FND_RESPONSIBILITY_TL

Line 31: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,

27: pa.effective_start_date l_effecttive_start_date,
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

Line 52: from AP_WEB_PROXY_ASSIGNMENTS pa, fnd_responsibility_tl b, fnd_user c,

48: pa.effective_start_date l_effecttive_start_date,
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