[Home] [Help]
838: p_k_party_id IN NUMBER
839: ) IS
840: SELECT per.full_name help_desk_name
841: FROM jtf_rs_resource_extns jtfrse,
842: oks_k_defaults gcd,
843: per_all_people_f per
844: WHERE jtfrse.user_id = gcd.user_id
845: AND per.person_id = jtfrse.source_id
846: AND per.effective_start_date = (SELECT MAX (a.effective_start_date)
851: AND jtfrse.category = 'EMPLOYEE'
852: AND gcd.segment_id1 = p_k_party_id;
853: /*
854: SELECT hd.help_desk_name
855: FROM oks_k_defaults gcd,
856: oks_help_desk_v hd
857: WHERE gcd.cdt_type = 'SDT'
858: AND gcd.jtot_object_code = 'OKX_PARTY'
859: AND gcd.user_id = hd.user_id
866: p_k_org_id IN NUMBER
867: ) IS
868: SELECT per.full_name help_desk_name
869: FROM jtf_rs_resource_extns jtfrse,
870: oks_k_defaults gcd,
871: per_all_people_f per
872: WHERE jtfrse.user_id = gcd.user_id
873: AND per.person_id = jtfrse.source_id
874: AND per.effective_start_date = (SELECT MAX (a.effective_start_date)
879: AND jtfrse.category = 'EMPLOYEE'
880: AND gcd.segment_id1 = p_k_org_id;
881: /*
882: SELECT hd.help_desk_name
883: FROM oks_k_defaults gcd,
884: oks_help_desk_v hd
885: WHERE gcd.cdt_type = 'SDT'
886: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
887: AND gcd.user_id = hd.user_id
892: -- bug 5218842
893: CURSOR csr_global_helpdesk IS
894: SELECT per.full_name help_desk_name
895: FROM jtf_rs_resource_extns jtfrse,
896: oks_k_defaults gcd,
897: per_all_people_f per
898: WHERE jtfrse.user_id = gcd.user_id
899: AND per.person_id = jtfrse.source_id
900: AND per.effective_start_date = (SELECT MAX (a.effective_start_date)
903: AND gcd.cdt_type = 'MDT'
904: AND jtfrse.category = 'EMPLOYEE';
905: /*
906: SELECT hd.help_desk_name
907: FROM oks_k_defaults gcd,
908: oks_help_desk_v hd
909: WHERE gcd.user_id = hd.user_id
910: AND gcd.cdt_type = 'MDT';
911: */
3614: p_k_party_id IN NUMBER
3615: ) IS
3616: SELECT gcd.email_address,
3617: fnd.user_name
3618: FROM oks_k_defaults gcd,
3619: fnd_user fnd
3620: WHERE gcd.user_id = fnd.user_id
3621: AND gcd.cdt_type = 'SDT'
3622: AND gcd.jtot_object_code = 'OKX_PARTY'
3627: p_k_org_id IN NUMBER
3628: ) IS
3629: SELECT gcd.email_address,
3630: fnd.user_name
3631: FROM oks_k_defaults gcd,
3632: fnd_user fnd
3633: WHERE gcd.user_id = fnd.user_id
3634: AND gcd.cdt_type = 'SDT'
3635: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3638:
3639: CURSOR csr_global_helpdesk IS
3640: SELECT gcd.email_address,
3641: fnd.user_name
3642: FROM oks_k_defaults gcd,
3643: fnd_user fnd
3644: WHERE gcd.user_id = fnd.user_id
3645: AND gcd.cdt_type = 'MDT';
3646: BEGIN