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 1042: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then

1038: lv_year varchar2(250);
1039: lv_st_dt varchar2(250);
1040: begin
1041: if to_number(p_tax_year) -
1042: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then
1043: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
1044: 12)-1,'DD-MON-YYYY');
1045: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
1046: 216), 'DD-MON-YYYY');

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

1041: if to_number(p_tax_year) -
1042: to_number(to_char(fnd_date.canonical_to_date(p_emp_dob),'YYYY')) = 18 then
1043: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
1044: 12)-1,'DD-MON-YYYY');
1045: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
1046: 216), 'DD-MON-YYYY');
1047: if fnd_date.canonical_to_date(p_hire_dt) <=
1048: trunc(to_date(p_tax_year,'YYYY'),'Y') then
1049: lv_st_dt := to_char(trunc(to_date(p_tax_year,'YYYY'),'Y'),

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

1043: lv_year := to_char(add_months(trunc(to_date(p_tax_year,'YYYY'),'Y'),
1044: 12)-1,'DD-MON-YYYY');
1045: lv_eighteen := to_char(add_months(fnd_date.canonical_to_date(p_emp_dob),
1046: 216), 'DD-MON-YYYY');
1047: if fnd_date.canonical_to_date(p_hire_dt) <=
1048: trunc(to_date(p_tax_year,'YYYY'),'Y') then
1049: lv_st_dt := to_char(trunc(to_date(p_tax_year,'YYYY'),'Y'),
1050: 'DD-MON-YYYY');
1051: else

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

1051: else
1052: lv_st_dt := p_hire_dt;
1053: end if;
1054: if p_termination_dt is not null and
1055: fnd_date.canonical_to_date(nvl(p_termination_dt,lv_year)) <
1056: fnd_date.canonical_to_date(lv_year)
1057: then
1058: lv_year := p_termination_dt;
1059: end if;

Line 1056: fnd_date.canonical_to_date(lv_year)

1052: lv_st_dt := p_hire_dt;
1053: end if;
1054: if p_termination_dt is not null and
1055: fnd_date.canonical_to_date(nvl(p_termination_dt,lv_year)) <
1056: fnd_date.canonical_to_date(lv_year)
1057: then
1058: lv_year := p_termination_dt;
1059: end if;
1060: hr_utility.set_message(801,'PAY_74040_EOY_EXCP_TURNS_18');