[Home] [Help]
48: HISTORY : 07/22/02 SYAO Initial Creation
49: 08/18/04 mumohan Bug#3838957: Added the condition to exclude
50: the end dated users in the cursors
51: get_approver_list and get_notification_list.
52: 08/03/05 raluthra Bug 4527617. Replaced the usage of fnd_user.
53: customer_id with fnd_user.person_party_id
54: for R12 ATG Mandate.
55: 08/05/05 raluthra Bug 4358517: Changed the definition of
56: l_org local variable from VARCHAR2(60) to
49: 08/18/04 mumohan Bug#3838957: Added the condition to exclude
50: the end dated users in the cursors
51: get_approver_list and get_notification_list.
52: 08/03/05 raluthra Bug 4527617. Replaced the usage of fnd_user.
53: customer_id with fnd_user.person_party_id
54: for R12 ATG Mandate.
55: 08/05/05 raluthra Bug 4358517: Changed the definition of
56: l_org local variable from VARCHAR2(60) to
57: pa_project_lists_v.carrying_out_organization_name%TYPE
296: IS
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.
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
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);
616:
617: CURSOR get_user_name
618: IS
619: SELECT user_name
620: FROM fnd_user
621: WHERE user_id = FND_GLOBAL.user_id;
622:
623:
624: CURSOR get_approver_list
625: IS
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 */
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
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))
831: IS
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 */
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
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
947: IS
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 */
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
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