APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on PER_ALL_PEOPLE_F

Line 843: per_all_people_f per

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

Line 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'

Line 871: per_all_people_f per

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

Line 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'

Line 897: per_all_people_f per

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

Line 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: /*