APPS.PA_CONTROL_ITEMS_WF_CLIENT dependencies on HZ_PARTIES

Line 281: hz_parties hp

277: IS
278: select hp.party_id
279: from pa_project_parties ppp,
280: pa_control_items pci,
281: hz_parties hp
282: where pci.ci_id = p_ci_id
283: and ppp.project_role_id = 1
284: and ppp.project_id = pci.project_id
285: and trunc(sysdate) between ppp.start_date_active and nvl(ppp.end_date_active, sysdate)

Line 297: hz_parties hp

293: select party_id from
294: (
295: select hp.party_id
296: from fnd_user fu,
297: hz_parties hp
298: where fu.user_id = fnd_global.user_id
299: and fu.employee_id is null
300: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
301: union

Line 304: hz_parties hp

300: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
301: union
302: select hp.party_id
303: from fnd_user fu,
304: hz_parties hp
305: where fu.user_id = fnd_global.user_id
306: and fu.employee_id is not null
307: and 'PER:' || fu.employee_id = hp.orig_system_reference);
308:

Line 326: pa_ci_types_b pcb, pa_lookups pl, hz_parties hp,

322: pcc.class_code classification,
323: pci.record_version_number record_version_number,
324: pl.meaning ci_type_class
325: FROM pa_control_items pci, pa_ci_types_tl pct,
326: pa_ci_types_b pcb, pa_lookups pl, hz_parties hp,
327: pa_class_codes pcc
328: WHERE ci_id = p_ci_id
329: and pci.ci_type_id = pct.ci_type_id
330: and pl.lookup_code = pcb.ci_type_class_code

Line 625: hz_parties hp

621: select user_name, party_name, email_address
622: from (
623: select fu.user_name, hp.party_name, hp.email_address
624: from fnd_user fu,
625: hz_parties hp
626: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
627: and hp.party_id = l_proj_mgr_id
628: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
629: union

Line 632: hz_parties hp,

628: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
629: union
630: select fu.user_name, hp.party_name, hp.email_address
631: from fnd_user fu,
632: hz_parties hp,
633: per_all_people_f papf
634: where
635: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
636: AND 'PER:' = Substr(hp.orig_system_reference,1,4) -- 'PER:' || fu.employee_id = hp.orig_system_reference

Line 830: hz_parties hp

826: select user_name, party_name, email_address
827: from (
828: select fu.user_name, hp.party_name, hp.email_address
829: from fnd_user fu,
830: hz_parties hp
831: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
832: and hp.party_id = l_owner_id
833: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
834: union

Line 837: hz_parties hp,

833: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
834: union
835: select fu.user_name, hp.party_name, hp.email_address
836: from fnd_user fu,
837: hz_parties hp,
838: per_all_people_f papf
839: where
840: --'PER:' || fu.employee_id = hp.orig_system_reference
841: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))