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.PER_IN_ORG_INFO_LEG_HOOK dependencies on FND_DATE

Line 1398: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))

1394: CURSOR chk_date_overlap_rep_ins(p_start_date DATE
1395: ,p_end_date DATE)IS
1396: SELECT 'X'
1397: FROM hr_organization_information hoi
1398: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1399: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1400: AND organization_id=p_organization_id
1401: AND org_information_context=p_org_info_type_code;
1402:

Line 1399: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)

1395: ,p_end_date DATE)IS
1396: SELECT 'X'
1397: FROM hr_organization_information hoi
1398: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1399: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1400: AND organization_id=p_organization_id
1401: AND org_information_context=p_org_info_type_code;
1402:
1403: ------------------------------------------------------------------

Line 1666: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1662: ,'IN_CONTRACTOR_EMPLOYERS_REP')
1663: THEN
1664:
1665: pay_in_utils.set_location(g_debug,l_procedure,70);
1666: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1667: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1668:
1669:
1670: ------check for start date is not greater than end date--------

Line 1667: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1663: THEN
1664:
1665: pay_in_utils.set_location(g_debug,l_procedure,70);
1666: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1667: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1668:
1669:
1670: ------check for start date is not greater than end date--------
1671:

Line 1706: l_start_date := fnd_date.canonical_to_date(p_org_information2);

1702:
1703: ELSIF p_org_info_type_code IN('IN_CONTRACTOR_WORK_INFO') THEN
1704:
1705: pay_in_utils.set_location(g_debug,l_procedure,95);
1706: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1707: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1708:
1709: --
1710: -- Check that the start date is not greater than end date

Line 1707: l_end_date := fnd_date.canonical_to_date(p_org_information3);

1703: ELSIF p_org_info_type_code IN('IN_CONTRACTOR_WORK_INFO') THEN
1704:
1705: pay_in_utils.set_location(g_debug,l_procedure,95);
1706: l_start_date := fnd_date.canonical_to_date(p_org_information2);
1707: l_end_date := fnd_date.canonical_to_date(p_org_information3);
1708:
1709: --
1710: -- Check that the start date is not greater than end date
1711: --

Line 1879: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))

1875: ,p_start_date DATE
1876: ,p_end_date DATE) IS
1877: SELECT 'X'
1878: FROM hr_organization_information hoi
1879: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1880: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1881: AND organization_id=p_organization_id
1882: AND org_information_id <>p_org_information_id
1883: AND org_information_context=p_org_info_type_code;

Line 1880: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)

1876: ,p_end_date DATE) IS
1877: SELECT 'X'
1878: FROM hr_organization_information hoi
1879: WHERE p_start_date <=nvl(fnd_date.canonical_to_date(hoi.org_information3),to_date('4712/12/31','YYYY/MM/DD'))
1880: AND nvl(p_end_date,to_date('4712/12/31','YYYY/MM/DD')) >=fnd_date.canonical_to_date(hoi.org_information2)
1881: AND organization_id=p_organization_id
1882: AND org_information_id <>p_org_information_id
1883: AND org_information_context=p_org_info_type_code;
1884:

Line 2175: l_start_date := fnd_date.canonical_to_date(p_org_information2);

2171:
2172:
2173: pay_in_utils.set_location(g_debug,l_procedure,90);
2174:
2175: l_start_date := fnd_date.canonical_to_date(p_org_information2);
2176: l_end_date := fnd_date.canonical_to_date(p_org_information3);
2177:
2178: --check start date is not greater than end date
2179:

Line 2176: l_end_date := fnd_date.canonical_to_date(p_org_information3);

2172:
2173: pay_in_utils.set_location(g_debug,l_procedure,90);
2174:
2175: l_start_date := fnd_date.canonical_to_date(p_org_information2);
2176: l_end_date := fnd_date.canonical_to_date(p_org_information3);
2177:
2178: --check start date is not greater than end date
2179:
2180: validate_date(p_effective_start_date=>l_start_date

Line 2220: l_start_date := fnd_date.canonical_to_date(p_org_information2);

2216:
2217:
2218: pay_in_utils.set_location(g_debug,l_procedure,125);
2219:
2220: l_start_date := fnd_date.canonical_to_date(p_org_information2);
2221: l_end_date := fnd_date.canonical_to_date(p_org_information3);
2222:
2223:
2224: --

Line 2221: l_end_date := fnd_date.canonical_to_date(p_org_information3);

2217:
2218: pay_in_utils.set_location(g_debug,l_procedure,125);
2219:
2220: l_start_date := fnd_date.canonical_to_date(p_org_information2);
2221: l_end_date := fnd_date.canonical_to_date(p_org_information3);
2222:
2223:
2224: --
2225: -- Check that the start date is not greater than end date

Line 3221: AND pay_in_utils.get_ee_value(pee.element_entry_id,'Challan or Voucher Number') like '% - %'||hoi.org_information3||'% - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')

3217: ,pay_element_types_f pet
3218: WHERE pet.element_name = 'Income Tax Challan Information'
3219: AND pet.legislation_code = 'IN'
3220: AND pee.element_type_id = pet.element_type_id
3221: AND pay_in_utils.get_ee_value(pee.element_entry_id,'Challan or Voucher Number') like '% - %'||hoi.org_information3||'% - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')
3222: AND hoi.org_information_context = 'PER_IN_IT_CHALLAN_INFO'
3223: AND hoi.org_information_id = p_org_information_id
3224: AND hoi.organization_id = p_organization_id
3225: AND (hoi.org_information3 <> p_org_information3 OR hoi.org_information2 <> p_org_information2)