APPS.PAY_JP_SPR_EFILE_PKG dependencies on FND_DATE

Line 394: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

390: pay_assignment_actions paa,
391: per_all_assignments_f pa,
392: pay_jp_wic_assacts_v pjwa
393: where ppa.effective_date
394: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
395: and ppa.business_group_id + 0 = to_number(''i_business_group_id'')
396: and pa.business_group_id + 0 = to_number(''i_business_group_id'')
397: and ppa.action_type in (''R'',''Q'',''B'',''I'')
398: and paa.payroll_action_id = ppa.payroll_action_id

Line 412: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))

408: per_addresses padc
409: where padr.person_id (+) = pjwa_v.pjwa_person_id
410: and padr.address_type (+) = ''JP_R''
411: and nvl(pjwa_v.actual_termination_date, add_months(trunc(pjwa_v.effective_date, ''YYYY''), 12))
412: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))
413: and padc.person_id (+) = pjwa_v.pjwa_person_id
414: and padc.address_type (+) = ''JP_C''
415: and nvl(pjwa_v.actual_termination_date, add_months(trunc(pjwa_v.effective_date, ''YYYY''), 12))
416: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,

Line 416: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,

412: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))
413: and padc.person_id (+) = pjwa_v.pjwa_person_id
414: and padc.address_type (+) = ''JP_C''
415: and nvl(pjwa_v.actual_termination_date, add_months(trunc(pjwa_v.effective_date, ''YYYY''), 12))
416: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,
417: (select pjsn_act.organization_id,
418: pjsn_act.district_code act_district_code,
419: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
420: pjsn_rep.swot_number rep_swot_number,

Line 484: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

480: --
481: c_proc_arch_where_clause varchar2(32767)
482: := 'ppa.business_group_id + 0 = to_number(''i_business_group_id'')
483: and ppa.effective_date
484: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
485: and ppa.action_type = ''X''
486: and ppa.report_type = ''JPTW''
487: and ppa.report_qualifier = ''JP''
488: and ppa.report_category = ''ARCHIVE''

Line 656: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter(''ITAX_DPNT_EFFECTIVE_DATE'',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,

652: pjwa.itax_organization_id,
653: pjwa.itax_category,
654: pjwa.itax_yea_category,
655: nvl(nvl(pap.prl_information1,''i_bg_itax_dpnt_ref_type''),''CTR_EE'') dpnt_ref_type,
656: nvl(fnd_date.canonical_to_date(pay_core_utils.get_parameter(''ITAX_DPNT_EFFECTIVE_DATE'',pjwa.legislative_parameters)),pjwa.effective_date) dpnt_effective_date,
657: pp.person_id,
658: pp.sex,
659: pp.date_of_birth,
660: pjwa.leaving_reason,

Line 692: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

688: and pjwa.assignment_action_id = paa.source_action_id
689: and pjwa.assignment_id = paa.assignment_id
690: and pjwa.business_group_id + 0 = to_number(''i_business_group_id'')
691: and pjwa.effective_date
692: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
693: and pjwa.itax_organization_id = nvl(to_number(''i_organization_id''),pjwa.itax_organization_id)
694: and pap.payroll_id = pjwa.payroll_id
695: and pjwa.effective_date
696: between pap.effective_start_date and pap.effective_end_date

Line 703: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))

699: between pp.effective_start_date and pp.effective_end_date
700: and padr.person_id (+) = pjwa.person_id
701: and padr.address_type (+) = ''JP_R''
702: and nvl(pjwa.actual_termination_date, add_months(trunc(pjwa.effective_date, ''YYYY''), 12))
703: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))
704: and padc.person_id (+) = pjwa.person_id
705: and padc.address_type (+) = ''JP_C''
706: and nvl(pjwa.actual_termination_date, add_months(trunc(pjwa.effective_date, ''YYYY''), 12))
707: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,

Line 707: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,

703: between padr.date_from (+) and nvl(padr.date_to(+), fnd_date.canonical_to_date(''i_eot''))
704: and padc.person_id (+) = pjwa.person_id
705: and padc.address_type (+) = ''JP_C''
706: and nvl(pjwa.actual_termination_date, add_months(trunc(pjwa.effective_date, ''YYYY''), 12))
707: between padc.date_from (+) and nvl(padc.date_to(+), fnd_date.canonical_to_date(''i_eot''))) wic_v,
708: (select pjsn_act.organization_id,
709: pjsn_act.district_code act_district_code,
710: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,
711: pjsn_rep.swot_number rep_swot_number,

Line 891: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

887: and ipaa.assignment_id = paa.assignment_id
888: and ippa.payroll_action_id = ipaa.payroll_action_id
889: and ippa.business_group_id + 0 = to_number(''i_business_group_id'')
890: and ippa.effective_date
891: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
892: and ippa.action_type = ''X''
893: and ippa.report_type = ''JPTW''
894: and ippa.report_qualifier = ''JP''
895: and ippa.report_category = ''ARCHIVE''

Line 1070: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

1066: and ipaa.assignment_id = paa.assignment_id
1067: and ippa.payroll_action_id = ipaa.payroll_action_id
1068: and ippa.business_group_id + 0 = to_number(''i_business_group_id'')
1069: and ippa.effective_date
1070: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
1071: and ippa.action_type = ''X''
1072: and ippa.report_type = ''JPTW''
1073: and ippa.report_qualifier = ''JP''
1074: and ippa.report_category = ''ARCHIVE''

Line 1246: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

1242: and ipaa.assignment_id = paa.assignment_id
1243: and ippa.payroll_action_id = ipaa.payroll_action_id
1244: and ippa.business_group_id + 0 = to_number(''i_business_group_id'')
1245: and ippa.effective_date
1246: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
1247: and ippa.action_type = ''X''
1248: and ippa.report_type = ''JPTW''
1249: and ippa.report_qualifier = ''JP''
1250: and ippa.report_category = ''ARCHIVE''

Line 1425: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')

1421: and ipaa.assignment_id = paa.assignment_id
1422: and ippa.payroll_action_id = ipaa.payroll_action_id
1423: and ippa.business_group_id + 0 = to_number(''i_business_group_id'')
1424: and ippa.effective_date
1425: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
1426: and ippa.action_type = ''X''
1427: and ippa.report_type = ''JPTW''
1428: and ippa.report_qualifier = ''JP''
1429: and ippa.report_category = ''ARCHIVE''

Line 1934: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')

1930: where ppa.payroll_action_id = :payroll_action_id
1931: and pp.business_group_id = ppa.business_group_id + 0
1932: and ppos.person_id = pp.person_id
1933: and ppos.business_group_id + 0 = pp.business_group_id
1934: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
1935: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1936: order by
1937: ppos.person_id';
1938: --

Line 1935: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')

1931: and pp.business_group_id = ppa.business_group_id + 0
1932: and ppos.person_id = pp.person_id
1933: and ppos.business_group_id + 0 = pp.business_group_id
1934: and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
1935: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1936: order by
1937: ppos.person_id';
1938: --
1939: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

Line 1939: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

1935: and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
1936: order by
1937: ppos.person_id';
1938: --
1939: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
1940: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
1941: --
1942: --end if;
1943: --

Line 1940: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

1936: order by
1937: ppos.person_id';
1938: --
1939: p_sqlstr := replace(p_sqlstr,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
1940: p_sqlstr := replace(p_sqlstr,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
1941: --
1942: --end if;
1943: --
1944: if g_debug then

Line 2087: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

2083: --
2084: l_select_clause := replace(l_select_clause,'i_valid_term_taxable_amt',to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
2085: --
2086: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2087: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2088: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2089: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2091: --

Line 2088: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

2084: l_select_clause := replace(l_select_clause,'i_valid_term_taxable_amt',to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
2085: --
2086: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2087: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2088: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2089: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2091: --
2092: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));

Line 2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));

2086: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2087: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2088: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2089: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2091: --
2092: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2093: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2094: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

Line 2093: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

2089: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2091: --
2092: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2093: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2094: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2095: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
2096: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
2097: --

Line 2094: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

2090: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2091: --
2092: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2093: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2094: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2095: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
2096: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
2097: --
2098: if g_debug

Line 2552: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

2548: -- set variable parameter
2549: --
2550: l_from_clause := replace(l_from_clause,'i_bg_itax_dpnt_ref_type',g_bg_itax_dpnt_ref_type);
2551: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2552: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2553: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2554: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2555: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));

Line 2553: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

2549: --
2550: l_from_clause := replace(l_from_clause,'i_bg_itax_dpnt_ref_type',g_bg_itax_dpnt_ref_type);
2551: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2552: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2553: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2554: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2555: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2557: --

Line 2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));

2552: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2553: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2554: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
2555: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2557: --
2558: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2559: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2560: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

Line 2559: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

2555: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2557: --
2558: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2559: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2560: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2561: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
2562: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
2563: --

Line 2560: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

2556: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
2557: --
2558: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
2559: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2560: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
2561: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
2562: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
2563: --
2564: if g_debug

Line 5153: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

5149: -- set variable parameter
5150: --
5151: l_from_clause := replace(l_from_clause,'i_bg_itax_dpnt_ref_type',g_bg_itax_dpnt_ref_type);
5152: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
5153: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5154: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
5155: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
5156: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));

Line 5154: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

5150: --
5151: l_from_clause := replace(l_from_clause,'i_bg_itax_dpnt_ref_type',g_bg_itax_dpnt_ref_type);
5152: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
5153: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5154: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
5155: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
5156: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
5158: --

Line 5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));

5153: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5154: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
5155: l_from_clause := replace(l_from_clause,'i_organization_id',to_char(g_organization_id));
5156: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
5158: --
5159: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
5160: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5161: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

Line 5160: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));

5156: l_from_clause := replace(l_from_clause,'i_district_code',g_district_code);
5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
5158: --
5159: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
5160: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5161: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
5162: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
5163: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
5164: --

Line 5161: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

5157: l_from_clause := replace(l_from_clause,'i_eot',fnd_date.date_to_canonical(hr_api.g_eot));
5158: --
5159: l_where_clause := replace(l_where_clause,'i_business_group_id',to_char(g_business_group_id));
5160: l_where_clause := replace(l_where_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
5161: l_where_clause := replace(l_where_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));
5162: l_where_clause := replace(l_where_clause,'i_organization_id',to_char(g_organization_id));
5163: l_where_clause := replace(l_where_clause,'i_district_code',g_district_code);
5164: --
5165: if g_debug