DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on WF_ROLES

Line 1072: from per_all_people_f ppf, wf_roles usr

1068:
1069: Cursor csr_person_valid_date
1070: is
1071: select 'Y'
1072: from per_all_people_f ppf, wf_roles usr
1073: where person_id = p_main_appraiser_id
1074: and business_group_id = p_business_group_id
1075: and p_effective_date between
1076: effective_start_date and nvl(effective_end_date,hr_api.g_eot)

Line 1087: from per_all_people_f ppf, wf_roles usr

1083:
1084: Cursor csr_cbg_person_valid_date
1085: is
1086: select 'Y'
1087: from per_all_people_f ppf, wf_roles usr
1088: where person_id = p_main_appraiser_id
1089: and p_effective_date between
1090: effective_start_date and nvl(effective_end_date,hr_api.g_eot)
1091: AND ppf.person_id = usr.orig_system_id