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

Line 357: FROM hr_organization_information hoi

353: ,hoi.org_information9
354: ,hoi.org_information10
355: ,hoi.org_information11
356: ,hoi.org_information12
357: FROM hr_organization_information hoi
358: WHERE hoi.organization_id = c_work_center
359: AND hoi.org_information_context = 'ES_WORK_CENTER_DETAILS';
360: --
361: BEGIN

Line 409: FROM hr_organization_information hoi

405: ,c_period_end_date DATE)IS
406: SELECT hoi2.org_information1 situation
407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id

Line 410: ,hr_organization_information hoi1

406: SELECT hoi2.org_information1 situation
407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
414: AND hoi.org_information1 = c_work_center

Line 412: ,hr_organization_information hoi2

408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
414: AND hoi.org_information1 = c_work_center
415: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
416: AND hoi1.organization_id = hou.organization_id

Line 715: FROM hr_organization_information hoi

711: */
712: --
713: CURSOR get_legal_employer_id(c_work_center_id NUMBER) IS
714: SELECT hoi.organization_id
715: FROM hr_organization_information hoi
716: WHERE hoi.org_information1 = c_work_center_id
717: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
718: --
719: l_def_bal_id NUMBER;

Line 1092: FROM hr_organization_information hoi

1088: ,c_period_end_date DATE) IS
1089: SELECT fnd_date.canonical_to_date(hoi.org_information1) Information_1
1090: ,nvl(fnd_date.canonical_to_date(hoi.org_information2),c_period_end_date) Information_2
1091: ,hoi.org_information3 Information_3
1092: FROM hr_organization_information hoi
1093: WHERE hoi.organization_id = c_work_center
1094: AND hoi.org_information_context = c_context --'ES_WC_PARTIAL_UNEMPLOYMENT'~~'ES_WC_NATURAL_DISASTER'
1095: ORDER BY 1;
1096: --

Line 1668: FROM hr_organization_information hoi

1664: */
1665: --
1666: CURSOR get_legal_employer_id(c_work_center_id NUMBER) IS
1667: SELECT hoi.organization_id
1668: FROM hr_organization_information hoi
1669: WHERE hoi.org_information1 = c_work_center_id
1670: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
1671: --
1672: l_def_bal_id NUMBER;