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_NL_ANNUAL_SI_FILE dependencies on FND_DATE

Line 362: FND_DATE.CANONICAL_TO_DATE(org_information1) and

358: where organization_id = p_employer_id
359: and org_information_context = 'NL_SIP'
360: and org_information4 = p_si_provider_id
361: AND p_process_date between
362: FND_DATE.CANONICAL_TO_DATE(org_information1) and
363: nvl(FND_DATE.CANONICAL_TO_DATE(org_information2),hr_general.end_of_time)
364: ORDER BY ORG_INFORMATION7,DECODE(org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
365:
366: l_number NUMBER;

Line 363: nvl(FND_DATE.CANONICAL_TO_DATE(org_information2),hr_general.end_of_time)

359: and org_information_context = 'NL_SIP'
360: and org_information4 = p_si_provider_id
361: AND p_process_date between
362: FND_DATE.CANONICAL_TO_DATE(org_information1) and
363: nvl(FND_DATE.CANONICAL_TO_DATE(org_information2),hr_general.end_of_time)
364: ORDER BY ORG_INFORMATION7,DECODE(org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
365:
366: l_number NUMBER;
367: l_si_type number;

Line 402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))

398: ,p_employer OUT NOCOPY NUMBER
399: ,p_org_struct_id OUT NOCOPY NUMBER ) IS
400: --
401: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
402: SELECT fnd_date.canonical_to_date(pay_core_utils.get_parameter('TAX_YEAR',legislative_parameters))
403: ,pay_core_utils.get_parameter('EMPLOYER_ID',legislative_parameters)
404: ,pay_core_utils.get_parameter('ORG_HIERARCHY',legislative_parameters)
405: ,pay_core_utils.get_parameter('SI_PROVIDER_ID',legislative_parameters)
406: ,effective_date