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

Line 226: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)

222: )
223:
224: and paa.assignment_id = pae_iza.assignment_id
225: and pae_iza.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
226: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)
227: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
228: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
229: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
230: and pae_sii.AEI_INFORMATION4 = '4'

Line 227: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)

223:
224: and paa.assignment_id = pae_iza.assignment_id
225: and pae_iza.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
226: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)
227: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
228: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
229: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
230: and pae_sii.AEI_INFORMATION4 = '4'
231: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)

Line 231: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)

227: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
228: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
229: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
230: and pae_sii.AEI_INFORMATION4 = '4'
231: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)
232: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)
233: and paa.assignment_id = pae_iza.assignment_id
234: and pae_iza.assignment_id = pae_sii.assignment_id
235: minus

Line 232: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)

228: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
229: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
230: and pae_sii.AEI_INFORMATION4 = '4'
231: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)
232: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)
233: and paa.assignment_id = pae_iza.assignment_id
234: and pae_iza.assignment_id = pae_sii.assignment_id
235: minus
236:

Line 297: g_element_type_id := pay_nl_general.get_element_type_id('Nominal IZA Contribution',fnd_date.canonical_to_date(p_effective_date));

293: l_batch_seq := 0;
294:
295: l_count := 0;
296:
297: g_element_type_id := pay_nl_general.get_element_type_id('Nominal IZA Contribution',fnd_date.canonical_to_date(p_effective_date));
298:
299:
300: l_filename := p_file_name;
301: fnd_profile.get (c_data_exchange_dir, l_location);

Line 353: (p_effective_date=> fnd_date.canonical_to_date (p_effective_date)

349: -- This create_batch_header procedure is a wrapper over the core
350: -- create_batch_header procedure defined in PAY_BATCH_ELEMENT_ENTRY_API
351:
352: create_batch_header
353: (p_effective_date=> fnd_date.canonical_to_date (p_effective_date)
354: ,p_name => p_batch_name
355: ,p_bg_id => p_business_group_id
356: ,p_action_if_exists => NVL (p_action_if_exists, c_default_action_if_exists)
357: ,p_date_effective_changes => p_date_effective_changes

Line 435: val_create_batch_line(l_line_read,l_batch_id,l_batch_seq,l_process_yr_mm,l_payroll_center,l_rec_org_id,l_org_struct_version_id,p_business_group_id,fnd_date.canonical_to_date(p_effective_date),l_batch_line_id,l_bl_ovn);

431: if g_debug then
432: hr_utility.set_location ( 'l_org_struct_version_id: ' || SUBSTR (l_org_struct_version_id, 1, 40), 350);
433: end if;
434:
435: val_create_batch_line(l_line_read,l_batch_id,l_batch_seq,l_process_yr_mm,l_payroll_center,l_rec_org_id,l_org_struct_version_id,p_business_group_id,fnd_date.canonical_to_date(p_effective_date),l_batch_line_id,l_bl_ovn);
436:
437: END IF;
438:
439: -- this is the case of a Closing Record

Line 1437: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)

1433: from PER_ASSIGNMENT_EXTRA_INFO pae_iza
1434: ,PER_ASSIGNMENT_EXTRA_INFO pae_sii
1435: where pae_iza.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
1436: and pae_iza.assignment_id = v_assignment_id
1437: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)
1438: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
1439: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
1440: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
1441: and pae_sii.AEI_INFORMATION4 = '4'

Line 1438: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)

1434: ,PER_ASSIGNMENT_EXTRA_INFO pae_sii
1435: where pae_iza.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
1436: and pae_iza.assignment_id = v_assignment_id
1437: and v_period_end_date >= fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION1)
1438: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
1439: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
1440: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
1441: and pae_sii.AEI_INFORMATION4 = '4'
1442: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)

Line 1442: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)

1438: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_iza.AEI_INFORMATION2),v_period_start_date)
1439: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
1440: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
1441: and pae_sii.AEI_INFORMATION4 = '4'
1442: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)
1443: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)
1444: and pae_sii.assignment_id = pae_iza.assignment_id;
1445:
1446:

Line 1443: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)

1439: and pae_sii.AEI_INFORMATION_CATEGORY = 'NL_SII'
1440: and pae_sii.AEI_INFORMATION3 in ('ZFW','AMI')
1441: and pae_sii.AEI_INFORMATION4 = '4'
1442: and v_period_end_date >= fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION1)
1443: and v_period_start_date <= NVL(fnd_date.canonical_to_date(pae_sii.AEI_INFORMATION2),v_period_start_date)
1444: and pae_sii.assignment_id = pae_iza.assignment_id;
1445:
1446:
1447: cursor csr_exchange_num_valid (v_org_id number,v_bg_id number,v_person_id number,v_period_start_date date,v_period_end_date date) IS