[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: */
3662: p_k_party_id IN NUMBER
3663: ) IS
3664: SELECT gcd.email_address,
3665: fnd.user_name
3666: FROM oks_k_defaults gcd,
3667: fnd_user fnd
3668: WHERE gcd.user_id = fnd.user_id
3669: AND gcd.cdt_type = 'SDT'
3670: AND gcd.jtot_object_code = 'OKX_PARTY'
3675: p_k_org_id IN NUMBER
3676: ) IS
3677: SELECT gcd.email_address,
3678: fnd.user_name
3679: FROM oks_k_defaults gcd,
3680: fnd_user fnd
3681: WHERE gcd.user_id = fnd.user_id
3682: AND gcd.cdt_type = 'SDT'
3683: AND gcd.jtot_object_code = 'OKX_OPERUNIT'
3686:
3687: CURSOR csr_global_helpdesk IS
3688: SELECT gcd.email_address,
3689: fnd.user_name
3690: FROM oks_k_defaults gcd,
3691: fnd_user fnd
3692: WHERE gcd.user_id = fnd.user_id
3693: AND gcd.cdt_type = 'MDT';
3694: BEGIN