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_IN_FORM_24Q_WEB_ADI dependencies on PER_ASSIGNMENTS_F

Line 207: ,per_assignments_f asg

203: IS
204: SELECT hoi.org_information1
205: FROM hr_organization_units hou
206: ,hr_organization_information hoi
207: ,per_assignments_f asg
208: ,hr_soft_coding_keyflex scl
209: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
210: AND asg.business_group_id = hou.business_group_id
211: AND asg.assignment_id = p_assignment_id

Line 839: ,per_assignments_f asg

835: ,element_link_id
836: ,asg.assignment_id
837: ,entry.object_version_number
838: FROM pay_element_entries_f entry
839: ,per_assignments_f asg
840: WHERE asg.business_group_id = p_business_group_id
841: AND asg.assignment_id = entry.assignment_id
842: AND entry.element_entry_id = p_element_entry_id
843: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date

Line 854: FROM per_assignments_f assgn

850: )
851: IS
852: SELECT types.element_type_id
853: ,link.element_link_id
854: FROM per_assignments_f assgn
855: , pay_element_links_f link
856: , pay_element_types_f types
857: WHERE assgn.assignment_id = p_assignment_id
858: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 903: ,per_assignments_f asg

899: )
900: IS
901: SELECT 1
902: FROM per_people_f pep
903: ,per_assignments_f asg
904: ,pay_element_entries_f entry
905: WHERE entry.element_entry_id = p_element_entry_id
906: AND asg.assignment_id = entry.assignment_id
907: AND asg.person_id = pep.person_id