APPS.PAY_CA_RL1_REG dependencies on FND_DATE

Line 90: to_date with fnd_date.canonical_to_date in

86: PRE in to tax unit id of asg act.
87: Changed sort_action cursor to use sort
88: options.
89: 18-Sep-2003 vpandya 115.20 Fix gscc date conversion error by replacing
90: to_date with fnd_date.canonical_to_date in
91: function get_rl1_message.
92: 25-Sep-2003 vpandya 115.21 Change sort action cursor and also changed
93: in c_all_asg c_all_asg_set cursor in
94: action creation. Bug 2633035.

Line 748: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then

744: lv_year varchar2(250);
745: lv_st_dt varchar2(250);
746: begin
747: if to_number(p_tax_year) -
748: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then
749: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
750: 12)-1,'DD-MON-YYYY');
751: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
752: 216), 'DD-MON-YYYY');

Line 751: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),

747: if to_number(p_tax_year) -
748: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then
749: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
750: 12)-1,'DD-MON-YYYY');
751: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
752: 216), 'DD-MON-YYYY');
753: if fnd_date.canonical_to_date(p_hire_dt) <=
754: trunc(to_date(p_tax_year,'YYYY'),'Y') then
755: lv_st_dt := to_char(trunc(to_date(p_tax_year,'YYYY'),'Y'),

Line 753: if fnd_date.canonical_to_date(p_hire_dt) <=

749: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
750: 12)-1,'DD-MON-YYYY');
751: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
752: 216), 'DD-MON-YYYY');
753: if fnd_date.canonical_to_date(p_hire_dt) <=
754: trunc(to_date(p_tax_year,'YYYY'),'Y') then
755: lv_st_dt := to_char(trunc(to_date(p_tax_year,'YYYY'),'Y'),
756: 'DD-MON-YYYY');
757: else

Line 761: fnd_date.canonical_to_date(nvl(p_termination_dt,lv_year)) <

757: else
758: lv_st_dt := p_hire_dt;
759: end if;
760: if p_termination_dt is not null and
761: fnd_date.canonical_to_date(nvl(p_termination_dt,lv_year)) <
762: fnd_date.canonical_to_date(lv_year)
763: then
764: lv_year := p_termination_dt;
765: end if;

Line 762: fnd_date.canonical_to_date(lv_year)

758: lv_st_dt := p_hire_dt;
759: end if;
760: if p_termination_dt is not null and
761: fnd_date.canonical_to_date(nvl(p_termination_dt,lv_year)) <
762: fnd_date.canonical_to_date(lv_year)
763: then
764: lv_year := p_termination_dt;
765: end if;
766: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');