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_SOE dependencies on HR_ORGANIZATION_INFORMATION

Line 11: ,HR_ORGANIZATION_INFORMATION hoi

7:
8: cursor csr_get_cvr_number (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
9: select hoi.org_information1
10: from hr_soft_coding_keyflex sck
11: ,HR_ORGANIZATION_INFORMATION hoi
12: ,per_all_assignments_f paa
13: where paa.assignment_id = p_assignment_id
14: and p_effective_date between paa.effective_start_date and paa.effective_end_date
15: and paa.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 24: ,HR_ORGANIZATION_INFORMATION hoi

20:
21: cursor csr_get_pension_provider (p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_effective_date Date ) is
22: select hou.name
23: from hr_soft_coding_keyflex sck
24: ,HR_ORGANIZATION_INFORMATION hoi
25: ,per_all_assignments_f paa
26: ,HR_ORGANIZATION_UNITS hou
27: where paa.assignment_id = p_assignment_id
28: and p_effective_date between paa.effective_start_date and paa.effective_end_date