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

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

153: WHERE addr.person_id = p_person_id
154: AND ( addr.primary_flag = 'Y'
155: OR addr.primary_flag IS NULL)
156: AND p_effective_date
157: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
158: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
159:
160: l_addr_rec csr_address%rowtype;
161:

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

154: AND ( addr.primary_flag = 'Y'
155: OR addr.primary_flag IS NULL)
156: AND p_effective_date
157: BETWEEN NVL(addr.date_from,fnd_date.canonical_to_date('0001/01/01 00:00:00'))
158: AND NVL(addr.date_to, fnd_date.canonical_to_date('4712/12/31 00:00:00'));
159:
160: l_addr_rec csr_address%rowtype;
161:
162: BEGIN

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

2127:
2128:
2129: cursor csr_advance_pay_dates
2130: is
2131: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2132: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2133: from pay_element_entries_f peef,
2134: pay_element_entry_values_f peevf ,
2135: pay_input_values_f pivf

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

2128:
2129: cursor csr_advance_pay_dates
2130: is
2131: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2132: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2133: from pay_element_entries_f peef,
2134: pay_element_entry_values_f peevf ,
2135: pay_input_values_f pivf
2136: where

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

2903:
2904:
2905: cursor csr_advance_pay_dates
2906: is
2907: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2908: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2909: from pay_element_entries_f peef,
2910: pay_element_entry_values_f peevf ,
2911: pay_input_values_f pivf

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

2904:
2905: cursor csr_advance_pay_dates
2906: is
2907: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2908: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2909: from pay_element_entries_f peef,
2910: pay_element_entry_values_f peevf ,
2911: pay_input_values_f pivf
2912: where

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

3706:
3707:
3708: cursor csr_advance_pay_dates
3709: is
3710: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3711: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3712: from pay_element_entries_f peef,
3713: pay_element_entry_values_f peevf ,
3714: pay_input_values_f pivf

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

3707:
3708: cursor csr_advance_pay_dates
3709: is
3710: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3711: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3712: from pay_element_entries_f peef,
3713: pay_element_entry_values_f peevf ,
3714: pay_input_values_f pivf
3715: where

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

6644: IS
6645: SELECT SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PRE_PAY_ID'),1,20) pre_pay_id,
6646: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,20) first_fps,
6647: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6648: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
6649: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission,
6650: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) final_submission,
6651: effective_date
6652: FROM pay_payroll_actions

Line 6650: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) final_submission,

6646: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,20) first_fps,
6647: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6648: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
6649: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission,
6650: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) final_submission,
6651: effective_date
6652: FROM pay_payroll_actions
6653: WHERE payroll_action_id = pactid;
6654:

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

6836: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'TAX_REF'),1,20) tax_ref,
6837: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS'),1,1) first_fps,
6838: effective_date,
6839: business_group_id,
6840: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date
6841: FROM pay_payroll_actions pact
6842: WHERE payroll_action_id = pactid;
6843:
6844: CURSOR csr_asg(c_asg_id NUMBER, c_effective_date DATE)

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

7213:
7214: -- Cursor to fetch the RTI NI Reporting assignment for this person.
7215: cursor csr_get_ni_rpt_asg(c_asg_id number) is
7216: select
7217: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
7218: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
7219: where paaf1.assignment_id = c_asg_id
7220: and paaf1.person_id = paaf2.person_id
7221: and paaf2.ASSIGNMENT_TYPE = 'E'

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

9145:
9146: -- Cursor to fetch the RTI NI Reporting assignment for this person.
9147: cursor csr_get_ni_rpt_asg(c_asg_id number) is
9148: select
9149: paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
9150: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
9151: where paaf1.assignment_id = c_asg_id
9152: and paaf1.person_id = paaf2.person_id
9153: and paaf2.ASSIGNMENT_TYPE = 'E'

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

9711: AND paa.assignment_action_id = pai.locked_action_id;
9712:
9713: -- To fetch First FPS parameter
9714: CURSOR csr_parameter_info IS
9715: SELECT fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIRST_FPS_DATE'),1,10)) first_fps_date,
9716: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PAYROLL_ID')) payroll_id
9717: FROM pay_payroll_actions pact,
9718: pay_assignment_actions paa
9719: WHERE paa.assignment_action_id = p_assactid

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

10074: CLOSE csr_last_action;
10075:
10076:
10077: hr_utility.trace('After csr_last_action, l_last_asg_action_id='||l_last_asg_action_id);
10078: hr_utility.trace('l_last_effective_date='||fnd_date.date_to_displaydate(l_last_effective_date));
10079: --
10080:
10081: hr_utility.set_location('Fetching person details ',10);
10082: l_archive_person := fetch_person_rec(p_assactid, l_last_effective_date,l_last_effective_date,l_archive_tab(0));

Line 13155: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) date_scheme

13151: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'P11D_DUE'),1,20) p11d_due,
13152: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'HMRC_ADVAN'),1,20) hmrc_advance_received,
13153: SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'CIS_DEDUCT'),1,20) cis_deductions,
13154: substr(legislative_parameters,instr(legislative_parameters,'VERSION=')+8) version,
13155: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'DATE_SCHEME'),1,10)) date_scheme
13156: FROM pay_payroll_actions
13157: WHERE payroll_action_id = pactid;
13158:
13159: l_payroll_rec csr_payroll_details%rowtype;

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

13481: OPEN get_person_details(action_id.assignment_id);
13482: FETCH get_person_details INTO et_asg_rec;
13483: CLOSE get_person_details;
13484: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
13485: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
13486: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
13487: || rpad(l_et_temp,50) );
13488: ELSE
13489: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '

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

13511:
13512: l_error_flag := 'Y';
13513:
13514: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
13515: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
13516: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
13517: || ' ' || rpad(err_msg,120) ); -- error message
13518: ELSE
13519: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

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

13561: IF csr_warn_msg%NOTFOUND THEN
13562: NULL;
13563: ELSE
13564: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
13565: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
13566: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
13567: || ' ' || rpad(err_msg,100) );
13568: ELSE
13569: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

Line 13708: p_action_information10 => fnd_date.date_to_canonical(l_parameter_info_rec.date_scheme));

13704: p_action_information6 => l_parameter_info_rec.employed_outside_uk ,
13705: p_action_information7 => l_parameter_info_rec.pay_to_third_party ,
13706: p_action_information8 => l_parameter_info_rec.p11d_due ,
13707: p_action_information9 => l_payroll_rec.service_company,
13708: p_action_information10 => fnd_date.date_to_canonical(l_parameter_info_rec.date_scheme));
13709: ---
13710: OPEN csr_is_etext_report;
13711: FETCH csr_is_etext_report INTO l_is_etext_report;
13712: CLOSE csr_is_etext_report;