DBA Data[Home] [Help]

APPS.GHR_HISTORY_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 614: l_asgn_data per_all_assignments_f%rowtype;

610: p_result_code out nocopy varchar2) is
611:
612: l_people_data per_all_people_f%rowtype;
613: l_asgei_data per_assignment_extra_info%rowtype;
614: l_asgn_data per_all_assignments_f%rowtype;
615: l_peopleei_data per_people_extra_info%rowtype;
616: l_element_entry_value_data pay_element_entry_values_f%rowtype;
617: l_element_entry_data pay_element_entries_f%rowtype;
618: l_posnei_data per_position_extra_info%rowtype;

Line 910: from per_all_assignments_f

906: cursor c1 (c_position_id number) is
907: select
908: assignment_id ,
909: person_id
910: from per_all_assignments_f
911: where position_id = c_position_id
912: and assignment_type <> 'B';
913:
914: cursor c2 (c_assignment_id number) is

Line 917: from per_all_assignments_f

913:
914: cursor c2 (c_assignment_id number) is
915: select
916: person_id
917: from per_all_assignments_f
918: where assignment_id = c_assignment_id
919: and assignment_type <> 'B';
920:
921: cursor c3 (c_element_entry_id number) is