DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on PER_ALL_PEOPLE_F

Line 691: from per_all_people_f

687: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
688:
689: cursor cur_roe_worksheet_person is
690: select full_name
691: from per_all_people_f
692: where person_id = to_number(p_roe_worksheet_person)
693: and fnd_date.canonical_to_date(p_date_earned)
694: between effective_start_date and effective_end_date;
695:

Line 698: from per_all_people_f

694: between effective_start_date and effective_end_date;
695:
696: cursor cur_roe_mag_media_person is
697: select full_name
698: from per_all_people_f
699: where person_id =
700: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
701: and fnd_date.canonical_to_date(p_date_earned)
702: between effective_start_date and effective_end_date;