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

Line 225: FROM per_all_assignments_f asg1

221: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
222: SELECT ee.element_entry_id element_entry_id
223: , eev1.screen_entry_value screen_entry_value
224: , iv1.name
225: FROM per_all_assignments_f asg1
226: ,per_all_assignments_f asg2
227: ,per_all_people_f per
228: ,pay_element_links_f el
229: ,pay_element_types_f et

Line 226: ,per_all_assignments_f asg2

222: SELECT ee.element_entry_id element_entry_id
223: , eev1.screen_entry_value screen_entry_value
224: , iv1.name
225: FROM per_all_assignments_f asg1
226: ,per_all_assignments_f asg2
227: ,per_all_people_f per
228: ,pay_element_links_f el
229: ,pay_element_types_f et
230: ,pay_input_values_f iv1

Line 374: ,PER_ALL_ASSIGNMENTS_F ASG

370: ,nvl(asg.frequency,hoi.org_information4) frequency
371: FROM
372: hr_organization_information hoi
373: ,HR_SOFT_CODING_KEYFLEX SCL
374: ,PER_ALL_ASSIGNMENTS_F ASG
375: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
376: AND hoi.organization_id = scl.segment1
377: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
378: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID

Line 411: FROM per_all_assignments_f paaf

407: RETURN DATE IS
408:
409: CURSOR csr_asg IS
410: SELECT MAX(paaf.effective_end_date) effective_end_date
411: FROM per_all_assignments_f paaf
412: WHERE paaf.business_group_id = p_business_group_id
413: AND paaf.assignment_id = p_assignment_id
414: AND paaf.assignment_status_type_id = 1;
415:

Line 473: FROM per_all_assignments_f asg1

469: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
470: SELECT ee.element_entry_id element_entry_id
471: , eev1.screen_entry_value screen_entry_value
472: , iv1.name
473: FROM per_all_assignments_f asg1
474: ,per_all_assignments_f asg2
475: ,per_all_people_f per
476: ,pay_element_links_f el
477: ,pay_element_types_f et

Line 474: ,per_all_assignments_f asg2

470: SELECT ee.element_entry_id element_entry_id
471: , eev1.screen_entry_value screen_entry_value
472: , iv1.name
473: FROM per_all_assignments_f asg1
474: ,per_all_assignments_f asg2
475: ,per_all_people_f per
476: ,pay_element_links_f el
477: ,pay_element_types_f et
478: ,pay_input_values_f iv1

Line 599: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf

595: FROM PER_ABSENCE_ATTENDANCES PAA
596: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
597:
598: CURSOR csr_person_details IS
599: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf
600: WHERE
601: paaf.assignment_id = p_assignment_id
602: AND p_date_earned BETWEEN paaf.effective_start_date AND paaf.effective_end_date
603: AND papf.person_id = paaf.person_id

Line 643: FROM per_all_assignments_f asg1

639: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
640: SELECT ee.element_entry_id element_entry_id
641: , eev1.screen_entry_value screen_entry_value
642: , iv1.name
643: FROM per_all_assignments_f asg1
644: ,per_all_assignments_f asg2
645: ,per_all_people_f per
646: ,pay_element_links_f el
647: ,pay_element_types_f et

Line 644: ,per_all_assignments_f asg2

640: SELECT ee.element_entry_id element_entry_id
641: , eev1.screen_entry_value screen_entry_value
642: , iv1.name
643: FROM per_all_assignments_f asg1
644: ,per_all_assignments_f asg2
645: ,per_all_people_f per
646: ,pay_element_links_f el
647: ,pay_element_types_f et
648: ,pay_input_values_f iv1

Line 796: FROM per_all_assignments_f asg1

792: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
793: SELECT ee.element_entry_id element_entry_id
794: , eev1.screen_entry_value screen_entry_value
795: , iv1.name
796: FROM per_all_assignments_f asg1
797: ,per_all_assignments_f asg2
798: ,per_all_people_f per
799: ,pay_element_links_f el
800: ,pay_element_types_f et

Line 797: ,per_all_assignments_f asg2

793: SELECT ee.element_entry_id element_entry_id
794: , eev1.screen_entry_value screen_entry_value
795: , iv1.name
796: FROM per_all_assignments_f asg1
797: ,per_all_assignments_f asg2
798: ,per_all_people_f per
799: ,pay_element_links_f el
800: ,pay_element_types_f et
801: ,pay_input_values_f iv1

Line 1079: ,PER_ALL_ASSIGNMENTS_F ASG

1075: ,segment10 work_pattern
1076: FROM
1077: hr_organization_information hoi
1078: ,HR_SOFT_CODING_KEYFLEX SCL
1079: ,PER_ALL_ASSIGNMENTS_F ASG
1080: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
1081: AND hoi.organization_id = scl.segment1
1082: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
1083: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID