APPS.PAY_CA_WF_PKG dependencies on PER_ALL_PEOPLE_F

Line 969: from per_all_people_f

965: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
966:
967: cursor cur_roe_worksheet_person is
968: select full_name
969: from per_all_people_f
970: where person_id = to_number(p_roe_worksheet_person)
971: and fnd_date.canonical_to_date(p_date_earned)
972: between effective_start_date and effective_end_date;
973:

Line 976: from per_all_people_f

972: between effective_start_date and effective_end_date;
973:
974: cursor cur_roe_mag_media_person is
975: select full_name
976: from per_all_people_f
977: where person_id =
978: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
979: and fnd_date.canonical_to_date(p_date_earned)
980: between effective_start_date and effective_end_date;

Line 3098: from per_all_people_f

3094: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
3095:
3096: cursor cur_roe_worksheet_person is
3097: select full_name
3098: from per_all_people_f
3099: where person_id = to_number(p_roe_worksheet_person)
3100: and fnd_date.canonical_to_date(p_date_earned)
3101: between effective_start_date and effective_end_date;
3102:

Line 3105: from per_all_people_f

3101: between effective_start_date and effective_end_date;
3102:
3103: cursor cur_roe_mag_media_person is
3104: select full_name
3105: from per_all_people_f
3106: where person_id =
3107: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
3108: and fnd_date.canonical_to_date(p_date_earned)
3109: between effective_start_date and effective_end_date;