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 256: FROM per_all_assignments_f asg1

252: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
253: SELECT ee.element_entry_id element_entry_id
254: , eev1.screen_entry_value screen_entry_value
255: , iv1.name
256: FROM per_all_assignments_f asg1
257: ,per_all_assignments_f asg2
258: ,per_all_people_f per
259: ,pay_element_links_f el
260: ,pay_element_types_f et

Line 257: ,per_all_assignments_f asg2

253: SELECT ee.element_entry_id element_entry_id
254: , eev1.screen_entry_value screen_entry_value
255: , iv1.name
256: FROM per_all_assignments_f asg1
257: ,per_all_assignments_f asg2
258: ,per_all_people_f per
259: ,pay_element_links_f el
260: ,pay_element_types_f et
261: ,pay_input_values_f iv1

Line 408: ,PER_ALL_ASSIGNMENTS_F ASG

404: ,nvl(asg.frequency,hoi.org_information4) frequency
405: FROM
406: hr_organization_information hoi
407: ,HR_SOFT_CODING_KEYFLEX SCL
408: ,PER_ALL_ASSIGNMENTS_F ASG
409: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
410: AND hoi.organization_id = scl.segment1
411: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
412: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID

Line 446: FROM per_all_assignments_f paaf

442: RETURN DATE IS
443:
444: CURSOR csr_asg IS
445: SELECT MAX(paaf.effective_end_date) effective_end_date
446: FROM per_all_assignments_f paaf
447: WHERE paaf.business_group_id = p_business_group_id
448: AND paaf.assignment_id = p_assignment_id
449: AND paaf.assignment_status_type_id = 1;
450:

Line 508: FROM per_all_assignments_f asg1

504: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
505: SELECT ee.element_entry_id element_entry_id
506: , eev1.screen_entry_value screen_entry_value
507: , iv1.name
508: FROM per_all_assignments_f asg1
509: ,per_all_assignments_f asg2
510: ,per_all_people_f per
511: ,pay_element_links_f el
512: ,pay_element_types_f et

Line 509: ,per_all_assignments_f asg2

505: SELECT ee.element_entry_id element_entry_id
506: , eev1.screen_entry_value screen_entry_value
507: , iv1.name
508: FROM per_all_assignments_f asg1
509: ,per_all_assignments_f asg2
510: ,per_all_people_f per
511: ,pay_element_links_f el
512: ,pay_element_types_f et
513: ,pay_input_values_f iv1

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

630: FROM PER_ABSENCE_ATTENDANCES PAA
631: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
632:
633: CURSOR csr_person_details IS
634: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf
635: WHERE
636: paaf.assignment_id = p_assignment_id
637: AND p_date_earned BETWEEN paaf.effective_start_date AND paaf.effective_end_date
638: AND papf.person_id = paaf.person_id

Line 678: FROM per_all_assignments_f asg1

674: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
675: SELECT ee.element_entry_id element_entry_id
676: , eev1.screen_entry_value screen_entry_value
677: , iv1.name
678: FROM per_all_assignments_f asg1
679: ,per_all_assignments_f asg2
680: ,per_all_people_f per
681: ,pay_element_links_f el
682: ,pay_element_types_f et

Line 679: ,per_all_assignments_f asg2

675: SELECT ee.element_entry_id element_entry_id
676: , eev1.screen_entry_value screen_entry_value
677: , iv1.name
678: FROM per_all_assignments_f asg1
679: ,per_all_assignments_f asg2
680: ,per_all_people_f per
681: ,pay_element_links_f el
682: ,pay_element_types_f et
683: ,pay_input_values_f iv1

Line 831: FROM per_all_assignments_f asg1

827: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
828: SELECT ee.element_entry_id element_entry_id
829: , eev1.screen_entry_value screen_entry_value
830: , iv1.name
831: FROM per_all_assignments_f asg1
832: ,per_all_assignments_f asg2
833: ,per_all_people_f per
834: ,pay_element_links_f el
835: ,pay_element_types_f et

Line 832: ,per_all_assignments_f asg2

828: SELECT ee.element_entry_id element_entry_id
829: , eev1.screen_entry_value screen_entry_value
830: , iv1.name
831: FROM per_all_assignments_f asg1
832: ,per_all_assignments_f asg2
833: ,per_all_people_f per
834: ,pay_element_links_f el
835: ,pay_element_types_f et
836: ,pay_input_values_f iv1

Line 1117: ,PER_ALL_ASSIGNMENTS_F ASG

1113: ,segment10 work_pattern
1114: FROM
1115: hr_organization_information hoi
1116: ,HR_SOFT_CODING_KEYFLEX SCL
1117: ,PER_ALL_ASSIGNMENTS_F ASG
1118: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
1119: AND hoi.organization_id = scl.segment1
1120: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
1121: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID