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)
847: FROM per_all_people_f a
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)
847: FROM per_all_people_f a
848: WHERE a.person_id = per.person_id)
849: AND gcd.cdt_type = 'SDT'
850: AND gcd.jtot_object_code = 'OKX_PARTY'
851: AND jtfrse.category = 'EMPLOYEE'
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)
875: FROM per_all_people_f a
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)
875: FROM per_all_people_f a
876: WHERE a.person_id = per.person_id)
877: AND gcd.cdt_type = 'SDT'
878: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
879: AND jtfrse.category = 'EMPLOYEE'
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)
901: FROM per_all_people_f a
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)
901: FROM per_all_people_f a
902: WHERE a.person_id = per.person_id)
903: AND gcd.cdt_type = 'MDT'
904: AND jtfrse.category = 'EMPLOYEE';
905: /*