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 FND_DATE

Line 407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date

403: ,c_type VARCHAR2
404: ,c_period_start_date DATE
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

Line 408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date

404: ,c_period_start_date DATE
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

Line 422: AND fnd_date.canonical_to_date(hoi2.org_information2) <= c_period_end_date

418: AND hou.organization_id = hoi.organization_id
419: AND hoi1.org_information_context = 'CLASS'
420: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
421: AND hoi2.org_information_context = c_type
422: AND fnd_date.canonical_to_date(hoi2.org_information2) <= c_period_end_date
423: and nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) >= c_period_start_date
424: ORDER BY hoi1.organization_id ;
425: --
426: l_ret pay_user_column_instances_f.value%type;

Line 423: and nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) >= c_period_start_date

419: AND hoi1.org_information_context = 'CLASS'
420: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
421: AND hoi2.org_information_context = c_type
422: AND fnd_date.canonical_to_date(hoi2.org_information2) <= c_period_end_date
423: and nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) >= c_period_start_date
424: ORDER BY hoi1.organization_id ;
425: --
426: l_ret pay_user_column_instances_f.value%type;
427: l_tot_days NUMBER;

Line 1089: SELECT fnd_date.canonical_to_date(hoi.org_information1) Information_1

1085: CURSOR csr_get_context_info(c_work_center NUMBER
1086: ,c_context VARCHAR2
1087: ,c_period_start_date DATE
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

Line 1090: ,nvl(fnd_date.canonical_to_date(hoi.org_information2),c_period_end_date) Information_2

1086: ,c_context VARCHAR2
1087: ,c_period_start_date DATE
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'