DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PER_ALL_PEOPLE_F

Line 750: per_all_people_f pap

746: pap.per_information1 place_residence , pap.business_group_id , pap.per_information23 fpin
747: FROM
748: pay_assignment_actions pac,
749: per_all_assignments_f assign,
750: per_all_people_f pap
751: WHERE pac.assignment_action_id = p_asg_act_id
752: AND assign.assignment_id = pac.assignment_id
753: AND assign.person_id = pap.person_id
754: AND pap.per_information_category = 'FI'

Line 836: ,per_all_people_f per

832: CURSOR csr_get_tax_card_type(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
833: SELECT eev1.screen_entry_value screen_entry_value
834: FROM per_all_assignments_f asg1
835: ,per_all_assignments_f asg2
836: ,per_all_people_f per
837: ,pay_element_links_f el
838: ,pay_element_types_f et
839: ,pay_input_values_f iv1
840: ,pay_element_entries_f ee