[Home] [Help]
281: IS
282: select hp.party_id
283: from pa_project_parties ppp,
284: pa_control_items pci,
285: hz_parties hp
286: where pci.ci_id = p_ci_id
287: and ppp.project_role_id = 1
288: and ppp.project_id = pci.project_id
289: and trunc(sysdate) between ppp.start_date_active and nvl(ppp.end_date_active, sysdate)
297: select party_id from
298: (
299: select hp.party_id
300: from fnd_user fu,
301: hz_parties hp
302: where fu.user_id = fnd_global.user_id
303: and fu.employee_id is null
304: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
305: union
304: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
305: union
306: select hp.party_id
307: from fnd_user fu,
308: hz_parties hp
309: where fu.user_id = fnd_global.user_id
310: and fu.employee_id is not null
311: and 'PER:' || fu.employee_id = hp.orig_system_reference);
312:
326: pcc.class_code classification,
327: pci.record_version_number record_version_number,
328: pl.meaning ci_type_class
329: FROM pa_control_items pci, pa_ci_types_tl pct,
330: pa_ci_types_b pcb, pa_lookups pl, hz_parties hp,
331: pa_class_codes pcc
332: WHERE ci_id = p_ci_id
333: and pci.ci_type_id = pct.ci_type_id
334: and pl.lookup_code = pcb.ci_type_class_code
626: select user_name, party_name, email_address
627: from (
628: select fu.user_name, hp.party_name, hp.email_address
629: from fnd_user fu,
630: hz_parties hp
631: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
632: and hp.party_id = l_proj_mgr_id
633: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
634: union
633: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
634: union
635: select fu.user_name, hp.party_name, hp.email_address
636: from fnd_user fu,
637: hz_parties hp,
638: per_all_people_f papf
639: where
640: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
641: AND 'PER:' = Substr(hp.orig_system_reference,1,4) -- 'PER:' || fu.employee_id = hp.orig_system_reference
832: select user_name, party_name, email_address
833: from (
834: select fu.user_name, hp.party_name, hp.email_address
835: from fnd_user fu,
836: hz_parties hp
837: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
838: and hp.party_id = l_owner_id
839: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
840: union
839: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
840: union
841: select fu.user_name, hp.party_name, hp.email_address
842: from fnd_user fu,
843: hz_parties hp,
844: per_all_people_f papf
845: where
846: --'PER:' || fu.employee_id = hp.orig_system_reference
847: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))
948: select user_name, party_name, email_address
949: from (
950: select fu.user_name, hp.party_name, hp.email_address
951: from fnd_user fu,
952: hz_parties hp
953: where fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
954: and hp.party_id = l_submitted_by_id
955: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
956: union
955: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
956: union
957: select fu.user_name, hp.party_name, hp.email_address
958: from fnd_user fu,
959: hz_parties hp,
960: per_all_people_f papf
961: where
962: --'PER:' || fu.employee_id = hp.orig_system_reference
963: fu.employee_id = Substr(hp.orig_system_reference, 5, Length(hp.orig_system_reference))