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

Line 282: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))

278: WHERE addr.person_id = p_person_id
279: AND ( addr.primary_flag = 'Y'
280: OR addr.primary_flag IS NULL)
281: AND p_effective_date
282: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
283: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
284:
285: l_addr_rec csr_address%rowtype;
286:

Line 283: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));

279: AND ( addr.primary_flag = 'Y'
280: OR addr.primary_flag IS NULL)
281: AND p_effective_date
282: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
283: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
284:
285: l_addr_rec csr_address%rowtype;
286:
287: BEGIN

Line 1626: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,

1622:
1623:
1624: cursor csr_advance_pay_dates
1625: is
1626: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
1627: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
1628: from pay_element_entries_f peef,
1629: pay_element_entry_values_f peevf ,
1630: pay_input_values_f pivf

Line 1627: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date

1623:
1624: cursor csr_advance_pay_dates
1625: is
1626: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
1627: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
1628: from pay_element_entries_f peef,
1629: pay_element_entry_values_f peevf ,
1630: pay_input_values_f pivf
1631: where

Line 2434: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,

2430:
2431:
2432: cursor csr_advance_pay_dates
2433: is
2434: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2435: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2436: from pay_element_entries_f peef,
2437: pay_element_entry_values_f peevf ,
2438: pay_input_values_f pivf

Line 2435: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date

2431:
2432: cursor csr_advance_pay_dates
2433: is
2434: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2435: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2436: from pay_element_entries_f peef,
2437: pay_element_entry_values_f peevf ,
2438: pay_input_values_f pivf
2439: where

Line 3248: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,

3244:
3245:
3246: cursor csr_advance_pay_dates
3247: is
3248: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3249: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3250: from pay_element_entries_f peef,
3251: pay_element_entry_values_f peevf ,
3252: pay_input_values_f pivf

Line 3249: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date

3245:
3246: cursor csr_advance_pay_dates
3247: is
3248: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3249: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3250: from pay_element_entries_f peef,
3251: pay_element_entry_values_f peevf ,
3252: pay_input_values_f pivf
3253: where

Line 6018: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date

6014: IS
6015: SELECT SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
6016: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,20) first_fps,
6017: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6018: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6019: FROM pay_payroll_actions
6020: WHERE payroll_action_id = pactid;
6021:
6022: CURSOR csr_get_payroll_id(c_pre_pact_id NUMBER)

Line 6169: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date

6165: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6166: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
6167: effective_date,
6168: business_group_id,
6169: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6170: FROM pay_payroll_actions pact
6171: WHERE payroll_action_id = pactid;
6172:
6173: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)

Line 6549: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)

6545:
6546: -- Cursor to fetch the RTI NI Reporting assignment for this person.
6547: cursor csr_get_ni_rpt_asg(c_asg_id number) is
6548: select
6549: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
6550: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
6551: where paaf1.assignment_id = c_asg_id
6552: and paaf1.person_id = paaf2.person_id
6553: and paaf2.ASSIGNMENT_TYPE = 'E'

Line 8515: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)

8511:
8512: -- Cursor to fetch the RTI NI Reporting assignment for this person.
8513: cursor csr_get_ni_rpt_asg(c_asg_id number) is
8514: select
8515: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
8516: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
8517: where paaf1.assignment_id = c_asg_id
8518: and paaf1.person_id = paaf2.person_id
8519: and paaf2.ASSIGNMENT_TYPE = 'E'

Line 9079: SELECT fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,

9075: AND paa.assignment_action_id = pai.locked_action_id;
9076:
9077: -- To fetch First FPS parameter
9078: CURSOR csr_parameter_info IS
9079: SELECT fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
9080: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id
9081: FROM pay_payroll_actions pact,
9082: pay_assignment_actions paa
9083: WHERE paa.assignment_action_id = p_assactid

Line 9431: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));

9427: CLOSE csr_last_action;
9428:
9429:
9430: hr_utility.trace('After csr_last_action, l_last_asg_action_id='||l_last_asg_action_id);
9431: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
9432: --
9433:
9434: hr_utility.set_location('Fetching person details ',10);
9435: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_last_effective_date,l_archive_tab(0));

Line 12730: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN

12726: OPEN get_person_details(action_id.assignment_id);
12727: FETCH get_person_details INTO et_asg_rec;
12728: CLOSE get_person_details;
12729: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
12730: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12731: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
12732: || rpad(l_et_temp,50) );
12733: ELSE
12734: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '

Line 12760: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN

12756:
12757: l_error_flag := 'Y';
12758:
12759: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
12760: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12761: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12762: || ' ' || rpad(err_msg,120) ); -- error message
12763: ELSE
12764: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

Line 12810: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN

12806: IF csr_warn_msg%NOTFOUND THEN
12807: NULL;
12808: ELSE
12809: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
12810: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12811: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12812: || ' ' || rpad(err_msg,100) );
12813: ELSE
12814: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)