eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE_EIN dependencies on PER_ALL_ASSIGNMENTS_F

Line 598: ,per_all_assignments_f as1

594: ,pay_payroll_actions appa2
595: ,pay_assignment_actions act
596: ,pay_assignment_actions act1
597: ,pay_action_interlocks pai
598: ,per_all_assignments_f as1
599: WHERE ppa.payroll_action_id = p_payroll_action_id
600: AND appa.effective_date BETWEEN l_canonical_start_date
601: AND l_canonical_end_date
602: AND as1.person_id BETWEEN p_start_person

Line 745: per_all_assignments_f assign,

741: pap.start_date, pap.business_group_id, assign.hourly_salaried_code HOURLY_SALARIED_CODE,
742: assign.assignment_number, assign.organization_id, assign.primary_flag
743: FROM
744: pay_assignment_actions pac,
745: per_all_assignments_f assign,
746: per_all_people_f pap
747: WHERE pac.assignment_action_id = p_asg_act_id
748: AND assign.assignment_id = pac.assignment_id
749: AND assign.person_id = pap.person_id

Line 821: FROM per_all_assignments_f asg1

817:
818: /* Cursor to retrieve Element - Employee ATP*/
819: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
820: SELECT eev1.screen_entry_value screen_entry_value
821: FROM per_all_assignments_f asg1
822: ,per_all_people_f per
823: ,pay_element_links_f el
824: ,pay_element_types_f et
825: ,pay_input_values_f iv1

Line 856: FROM per_all_assignments_f asg1

852:
853: /* Cursor to retrieve Element - Tax Card*/
854: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
855: SELECT ee.effective_start_date, eev1.screen_entry_value
856: FROM per_all_assignments_f asg1
857: ,per_all_people_f per
858: ,pay_element_links_f el
859: ,pay_element_types_f et
860: ,pay_input_values_f iv1

Line 895: FROM per_all_assignments_f paa

891: ,p_start_date DATE
892: ,p_end_date DATE
893: ,p_business_group_id NUMBER) IS
894: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
895: FROM per_all_assignments_f paa
896: ,pay_assignment_actions pac
897: WHERE pac.assignment_action_id = p_asg_act_id
898: AND paa.assignment_id = pac.assignment_id
899: AND paa.EFFECTIVE_START_DATE <= p_end_date