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

Line 96: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date

92: FROM
93: per_all_assignments_f pasg,
94: per_all_assignments_f asg
95: WHERE asg.assignment_id = asgid
96: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
97: AND pasg.person_id = asg.person_id
98: AND pasg.primary_flag = 'Y'
99: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
100: BEGIN

Line 99: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;

95: WHERE asg.assignment_id = asgid
96: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
97: AND pasg.person_id = asg.person_id
98: AND pasg.primary_flag = 'Y'
99: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
100: BEGIN
101:
102: if g_debug then
103: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 133: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)

129: ,p_additional_rate => p_additional_rate
130: ,p_override_manual_upd => p_override_manual_upd
131: ,p_previous_income => p_previous_income
132: ,p_yearly_income_limit => p_yearly_income_limit
133: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
134: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
135: ,p_lower_income_percentage => p_lower_income_percentage);
136: if g_debug then
137: hr_utility.set_location('Leaving:'|| l_proc, 2);

Line 134: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)

130: ,p_override_manual_upd => p_override_manual_upd
131: ,p_previous_income => p_previous_income
132: ,p_yearly_income_limit => p_yearly_income_limit
133: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
134: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
135: ,p_lower_income_percentage => p_lower_income_percentage);
136: if g_debug then
137: hr_utility.set_location('Leaving:'|| l_proc, 2);
138: end if;

Line 297: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN

293: pay_input_values_f iv
294: WHERE et.element_name = 'Tax Card'
295: AND et.legislation_code = 'FI'
296: AND et.business_group_id is null
297: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
298: et.effective_start_date AND et.effective_end_date
299: AND iv.element_type_id = et.element_type_id
300: AND fnd_date.canonical_to_date(p_effective_date)
301: BETWEEN iv.effective_start_date AND iv.effective_end_date

Line 300: AND fnd_date.canonical_to_date(p_effective_date)

296: AND et.business_group_id is null
297: AND fnd_date.canonical_to_date(p_effective_date) BETWEEN
298: et.effective_start_date AND et.effective_end_date
299: AND iv.element_type_id = et.element_type_id
300: AND fnd_date.canonical_to_date(p_effective_date)
301: BETWEEN iv.effective_start_date AND iv.effective_end_date
302: GROUP BY
303: et.element_type_id;
304:

Line 338: fnd_date.date_to_canonical(p_effective_date),

334: end if;
335: -- fetch element link id
336: l_element_link_id := pay_fi_tc_dp_upload.get_element_link_id(
337: p_assignment_id, p_business_group_id,
338: fnd_date.date_to_canonical(p_effective_date),
339: 'Tax Card');
340: l_element_entry_id := p_element_entry_id_tc;
341: if g_debug then
342: hr_utility.set_location('Leaving:'|| l_proc, 2);

Line 387: ,p_entry_value9 => fnd_date.canonical_to_date(p_date_returned)

383: ,p_entry_value5 => p_additional_rate
384: ,p_entry_value6 => p_override_manual_upd
385: ,p_entry_value7 => p_previous_income
386: ,p_entry_value8 => p_yearly_income_limit
387: ,p_entry_value9 => fnd_date.canonical_to_date(p_date_returned)
388: ,p_entry_value10 => fnd_date.canonical_to_date(p_registration_date)
389: ,p_entry_value11 => p_lower_income_percentage
390: ,p_effective_start_date => l_start_date
391: ,p_effective_end_date => l_end_date

Line 388: ,p_entry_value10 => fnd_date.canonical_to_date(p_registration_date)

384: ,p_entry_value6 => p_override_manual_upd
385: ,p_entry_value7 => p_previous_income
386: ,p_entry_value8 => p_yearly_income_limit
387: ,p_entry_value9 => fnd_date.canonical_to_date(p_date_returned)
388: ,p_entry_value10 => fnd_date.canonical_to_date(p_registration_date)
389: ,p_entry_value11 => p_lower_income_percentage
390: ,p_effective_start_date => l_start_date
391: ,p_effective_end_date => l_end_date
392: ,p_element_entry_id => l_element_entry_id

Line 492: AND fnd_date.canonical_to_date(p_effective_date)

488: pay_input_values_f iv
489: WHERE et.element_name = 'Tax'
490: AND et.legislation_code = 'FI'
491: AND et.business_group_id is null
492: AND fnd_date.canonical_to_date(p_effective_date)
493: BETWEEN et.effective_start_date AND et.effective_end_date
494: AND iv.element_type_id = et.element_type_id
495: AND fnd_date.canonical_to_date(p_effective_date)
496: BETWEEN iv.effective_start_date AND iv.effective_end_date

Line 495: AND fnd_date.canonical_to_date(p_effective_date)

491: AND et.business_group_id is null
492: AND fnd_date.canonical_to_date(p_effective_date)
493: BETWEEN et.effective_start_date AND et.effective_end_date
494: AND iv.element_type_id = et.element_type_id
495: AND fnd_date.canonical_to_date(p_effective_date)
496: BETWEEN iv.effective_start_date AND iv.effective_end_date
497: GROUP BY
498: et.element_type_id;
499:

Line 519: AND fnd_date.chardate_to_date(l_effective_date)

515: pay_element_entries_f pee
516: WHERE pet.element_name = l_element_name
517: AND pet.legislation_code = 'FI'
518: AND pet.business_group_id IS NULL
519: AND fnd_date.chardate_to_date(l_effective_date)
520: BETWEEN pet.effective_start_date AND pet.effective_end_date
521: AND pel.element_type_id = pet.element_type_id
522: AND pel.business_group_id = l_business_grp_id
523: AND fnd_date.chardate_to_date(l_effective_date)

Line 523: AND fnd_date.chardate_to_date(l_effective_date)

519: AND fnd_date.chardate_to_date(l_effective_date)
520: BETWEEN pet.effective_start_date AND pet.effective_end_date
521: AND pel.element_type_id = pet.element_type_id
522: AND pel.business_group_id = l_business_grp_id
523: AND fnd_date.chardate_to_date(l_effective_date)
524: BETWEEN pel.effective_start_date AND pel.effective_end_date
525: AND pee.element_link_id = pel.element_link_id
526: AND fnd_date.chardate_to_date(l_effective_date)
527: BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 526: AND fnd_date.chardate_to_date(l_effective_date)

522: AND pel.business_group_id = l_business_grp_id
523: AND fnd_date.chardate_to_date(l_effective_date)
524: BETWEEN pel.effective_start_date AND pel.effective_end_date
525: AND pee.element_link_id = pel.element_link_id
526: AND fnd_date.chardate_to_date(l_effective_date)
527: BETWEEN pee.effective_start_date AND pee.effective_end_date
528: AND pee.assignment_id = l_asgid;
529: lrIsElementAttached cIsElementAttached%ROWTYPE;
530: l_proc varchar2(72) := g_package||'insert_tax.';

Line 554: fnd_date.date_to_canonical(p_effective_date),

550: end if;
551: -- fetch element link id
552: l_element_link_id := pay_fi_tc_dp_upload.get_element_link_id(
553: p_assignment_id, p_business_group_id,
554: fnd_date.date_to_canonical(p_effective_date),
555: 'Tax');
556: l_element_entry_id := p_element_entry_id_t;
557: if g_debug then
558: hr_utility.set_location('Leaving:'|| l_proc, 2);

Line 850: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date

846: FROM
847: per_all_assignments_f pasg,
848: per_all_assignments_f asg
849: WHERE asg.assignment_id = asgid
850: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
851: AND pasg.person_id = asg.person_id
852: AND pasg.primary_flag = 'Y'
853: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
854: l_datetrack_update_mode VARCHAR2(255);

Line 853: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;

849: WHERE asg.assignment_id = asgid
850: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
851: AND pasg.person_id = asg.person_id
852: AND pasg.primary_flag = 'Y'
853: AND fnd_date.canonical_to_date(effective_date) BETWEEN pasg.effective_start_date AND pasg.effective_end_date;
854: l_datetrack_update_mode VARCHAR2(255);
855: l_record_started_today BOOLEAN;
856: BEGIN
857: l_datetrack_update_mode := p_datetrack_update_mode;

Line 931: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)

927: ,p_additional_rate => p_additional_rate
928: ,p_override_manual_upd => p_override_manual_upd
929: ,p_previous_income => p_previous_income
930: ,p_yearly_income_limit => p_yearly_income_limit
931: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
932: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
933: ,p_lower_income_percentage => p_lower_income_percentage);
934:
935:

Line 932: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)

928: ,p_override_manual_upd => p_override_manual_upd
929: ,p_previous_income => p_previous_income
930: ,p_yearly_income_limit => p_yearly_income_limit
931: ,p_date_returned => fnd_date.canonical_to_date(p_date_returned)
932: ,p_registration_date => fnd_date.canonical_to_date(p_registration_date)
933: ,p_lower_income_percentage => p_lower_income_percentage);
934:
935:
936: END IF;

Line 1450: AND fnd_date.canonical_to_date(l_effective_date)

1446: pay_element_entries_f pee
1447: WHERE pet.element_name = l_element_name
1448: AND pet.legislation_code = 'FI'
1449: AND pet.business_group_id IS NULL
1450: AND fnd_date.canonical_to_date(l_effective_date)
1451: BETWEEN pet.effective_start_date AND pet.effective_end_date
1452: AND pel.element_type_id = pet.element_type_id
1453: AND pel.business_group_id = l_business_grp_id
1454: AND fnd_date.canonical_to_date(l_effective_date)

Line 1454: AND fnd_date.canonical_to_date(l_effective_date)

1450: AND fnd_date.canonical_to_date(l_effective_date)
1451: BETWEEN pet.effective_start_date AND pet.effective_end_date
1452: AND pel.element_type_id = pet.element_type_id
1453: AND pel.business_group_id = l_business_grp_id
1454: AND fnd_date.canonical_to_date(l_effective_date)
1455: BETWEEN pel.effective_start_date AND pel.effective_end_date
1456: AND pee.element_link_id = pel.element_link_id
1457: AND fnd_date.canonical_to_date(l_effective_date)
1458: BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 1457: AND fnd_date.canonical_to_date(l_effective_date)

1453: AND pel.business_group_id = l_business_grp_id
1454: AND fnd_date.canonical_to_date(l_effective_date)
1455: BETWEEN pel.effective_start_date AND pel.effective_end_date
1456: AND pee.element_link_id = pel.element_link_id
1457: AND fnd_date.canonical_to_date(l_effective_date)
1458: BETWEEN pee.effective_start_date AND pee.effective_end_date
1459: AND pee.assignment_id = l_asgid;
1460:
1461: BEGIN

Line 1560: AND fnd_date.chardate_to_date(effective_date) BETWEEN

1556: effective_date IN VARCHAR2) IS
1557: SELECT asg.primary_flag
1558: FROM per_all_assignments_f asg
1559: WHERE asg.assignment_id = asgid
1560: AND fnd_date.chardate_to_date(effective_date) BETWEEN
1561: asg.effective_start_date AND asg.effective_end_date;
1562: BEGIN
1563: OPEN cIsPrimaryAsg(p_assignment_id , p_effective_date);
1564: FETCH cIsPrimaryAsg INTO l_csr_result;

Line 1623: AND fnd_date.chardate_to_date(l_effective_date)

1619: pay_element_entries_f pee
1620: WHERE pet.element_name = l_element_name
1621: AND pet.legislation_code = 'FI'
1622: AND pet.business_group_id IS NULL
1623: AND fnd_date.chardate_to_date(l_effective_date)
1624: BETWEEN pet.effective_start_date AND pet.effective_end_date
1625: AND pel.element_type_id = pet.element_type_id
1626: AND pel.business_group_id = l_business_grp_id
1627: AND fnd_date.chardate_to_date(l_effective_date)

Line 1627: AND fnd_date.chardate_to_date(l_effective_date)

1623: AND fnd_date.chardate_to_date(l_effective_date)
1624: BETWEEN pet.effective_start_date AND pet.effective_end_date
1625: AND pel.element_type_id = pet.element_type_id
1626: AND pel.business_group_id = l_business_grp_id
1627: AND fnd_date.chardate_to_date(l_effective_date)
1628: BETWEEN pel.effective_start_date AND pel.effective_end_date
1629: AND pee.element_link_id = pel.element_link_id
1630: AND fnd_date.chardate_to_date(l_effective_date)
1631: BETWEEN pee.effective_start_date AND pee.effective_end_date

Line 1630: AND fnd_date.chardate_to_date(l_effective_date)

1626: AND pel.business_group_id = l_business_grp_id
1627: AND fnd_date.chardate_to_date(l_effective_date)
1628: BETWEEN pel.effective_start_date AND pel.effective_end_date
1629: AND pee.element_link_id = pel.element_link_id
1630: AND fnd_date.chardate_to_date(l_effective_date)
1631: BETWEEN pee.effective_start_date AND pee.effective_end_date
1632: AND pee.assignment_id = l_asgid;
1633:
1634: BEGIN