APPS.PER_GB_P11D_REPORTS dependencies on FND_DATE

Line 67: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_ben_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') then

63: open csr_ben_end_date;
64: fetch csr_ben_end_date into l_ben_end_date;
65: close csr_ben_end_date;
66: --
67: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(l_ben_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') then
68: l_report_name := p_p11d_main_report_2003;
69: else
70: l_report_name := p_p11d_main_report_2002;
71: end if;

Line 122: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2004/04/06') then

118: l_report_name varchar2(100);
119: begin
120:
121: /* print report for 2005
122: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2004/04/06') then
123: l_report_name := p_p11d_gaps_report_2005;
124: */
125: /* To print Gap and Overlap report for 2004*/
126: /*Bug No. 3201848*/

Line 127: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2003/04/06') then

123: l_report_name := p_p11d_gaps_report_2005;
124: */
125: /* To print Gap and Overlap report for 2004*/
126: /*Bug No. 3201848*/
127: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2003/04/06') then
128: l_report_name := p_p11d_gaps_report_2004;
129: elsif fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') and
130: fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) <= fnd_date.canonical_to_date('2003/04/05') then
131: l_report_name := p_p11d_gaps_report_2003;

Line 129: elsif fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') and

125: /* To print Gap and Overlap report for 2004*/
126: /*Bug No. 3201848*/
127: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2003/04/06') then
128: l_report_name := p_p11d_gaps_report_2004;
129: elsif fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') and
130: fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) <= fnd_date.canonical_to_date('2003/04/05') then
131: l_report_name := p_p11d_gaps_report_2003;
132: else
133: l_report_name := p_p11d_gaps_report_2002;

Line 130: fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) <= fnd_date.canonical_to_date('2003/04/05') then

126: /*Bug No. 3201848*/
127: if fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2003/04/06') then
128: l_report_name := p_p11d_gaps_report_2004;
129: elsif fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) >= fnd_date.canonical_to_date('2002/04/06') and
130: fnd_date.canonical_to_date(fnd_date.string_to_canonical(p_benefit_end_date,'dd-mon-rrrr')) <= fnd_date.canonical_to_date('2003/04/05') then
131: l_report_name := p_p11d_gaps_report_2003;
132: else
133: l_report_name := p_p11d_gaps_report_2002;
134: end if;