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

Line 82: FROM hr_organization_information

78: l_dummy VARCHAR2(1);
79:
80: CURSOR c_dup_comb IS
81: SELECT 'X'
82: FROM hr_organization_information
83: WHERE organization_id = p_organization_id
84: AND org_information_context = p_org_info_type_code
85: AND org_information1 = p_emp_category
86: AND org_information_id <> NVL(p_org_information_id,0);

Line 1776: FROM hr_organization_information hoi

1772: AND paf.effective_end_date;
1773:
1774: CURSOR csr_np (p_emp_category IN VARCHAR2) IS
1775: SELECT hoi.org_information2
1776: FROM hr_organization_information hoi
1777: WHERE hoi.organization_id = p_business_group_id
1778: AND hoi.org_information_context = 'PER_IN_NOTICE_DF'
1779: AND hoi.org_information1 = p_emp_category;
1780: