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_EHOL dependencies on PER_ALL_ASSIGNMENTS_F

Line 691: ,per_all_assignments_f as1

687: ,pay_payroll_actions appa2
688: ,pay_assignment_actions act
689: ,pay_assignment_actions act1
690: ,pay_action_interlocks pai
691: ,per_all_assignments_f as1
692: WHERE ppa.payroll_action_id = p_payroll_action_id
693: AND appa.effective_date BETWEEN l_canonical_start_date
694: AND l_canonical_end_date
695: AND as1.person_id BETWEEN p_start_person

Line 743: FROM per_all_assignments_f

739:
740: Cursor cur_term_date(p_start_date DATE, p_bg_id number, p_asg_id number)
741: IS
742: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
743: FROM per_all_assignments_f
744: WHERE
745: assignment_id = p_asg_id
746: AND EFFECTIVE_END_DATE > = p_start_date
747: AND assignment_status_type_id IN

Line 971: per_all_assignments_f assign,

967: assign.hourly_salaried_code HOURLY_SALARIED_CODE, assign.assignment_number, assign.organization_id, assign.primary_flag,
968: assign.location_id
969: FROM
970: pay_assignment_actions pac,
971: per_all_assignments_f assign,
972: per_all_people_f pap
973: WHERE pac.assignment_action_id = p_asg_act_id
974: AND assign.assignment_id = pac.assignment_id
975: AND assign.person_id = pap.person_id

Line 1023: ,per_all_assignments_f paaf

1019: ,scl.SEGMENT22 FO_CODE
1020: ,NVL(scl.SEGMENT23,'FH1') FH_CODE
1021: FROM
1022: per_all_people_f papf
1023: ,per_all_assignments_f paaf
1024: ,pay_payrolls_f ppf
1025: ,hr_soft_coding_keyflex scl
1026: WHERE paaf.person_id = p_person_id
1027: AND papf.PERSON_ID = paaf.PERSON_ID

Line 1291: FROM per_all_assignments_f asg1

1287:
1288: /* Cursor to retrieve Element - Employee ATP*/
1289: CURSOR csr_get_atp_table_value(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1290: SELECT eev1.screen_entry_value screen_entry_value
1291: FROM per_all_assignments_f asg1
1292: ,per_all_people_f per
1293: ,pay_element_links_f el
1294: ,pay_element_types_f et
1295: ,pay_input_values_f iv1

Line 1326: FROM per_all_assignments_f asg1

1322:
1323: /* Cursor to retrieve Element - Tax Card*/
1324: CURSOR csr_get_tax_card_details(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
1325: SELECT ee.effective_start_date, eev1.screen_entry_value
1326: FROM per_all_assignments_f asg1
1327: ,per_all_people_f per
1328: ,pay_element_links_f el
1329: ,pay_element_types_f et
1330: ,pay_input_values_f iv1

Line 1365: FROM per_all_assignments_f paa

1361: ,p_start_date DATE
1362: ,p_end_date DATE
1363: ,p_business_group_id NUMBER) IS
1364: SELECT MAX( EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
1365: FROM per_all_assignments_f paa
1366: ,pay_assignment_actions pac
1367: WHERE pac.assignment_action_id = p_asg_act_id
1368: AND paa.assignment_id = pac.assignment_id
1369: -- AND paa.EFFECTIVE_START_DATE <= p_end_date 10322958

Line 1427: ,per_all_assignments_f as1

1423: ,pay_payroll_actions appa2
1424: ,pay_assignment_actions act
1425: ,pay_assignment_actions act1
1426: ,pay_action_interlocks pai
1427: ,per_all_assignments_f as1
1428:
1429: WHERE ppa.payroll_action_id = p_payroll_action_id
1430: AND appa.effective_date BETWEEN l_canonical_start_date
1431: AND l_canonical_end_date