APPS.PER_JP_WRKREG_REPORT_PKG dependencies on FND_DATE

Line 274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date

270: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
271: ,NVL(pay_core_utils.get_parameter('IOH',legislative_parameters),'Y') include_org_hierarchy
272: ,pay_core_utils.get_parameter('ORG',legislative_parameters) organization_id
273: ,pay_core_utils.get_parameter('LOC',legislative_parameters) location_id
274: ,FND_DATE.canonical_to_date(pay_core_utils.get_parameter('EFFDATE',legislative_parameters)) effective_date
275: ,NVL(pay_core_utils.get_parameter('S1',legislative_parameters),'ZZ') sort_order_1
276: ,NVL(pay_core_utils.get_parameter('S2',legislative_parameters),'ZZ') sort_order_2
277: ,NVL(pay_core_utils.get_parameter('S3',legislative_parameters),'ZZ') sort_order_3
278: ,pay_core_utils.get_parameter('ITE',legislative_parameters) incl_term_emp

Line 1179: AND p_effective_date BETWEEN fnd_date.canonical_to_date(HOI.org_information5)

1175: WHERE HOI.org_information_context = 'JP_REPORTS_ADDITIONAL_INFO'
1176: AND HOI.org_information1 = 'JPEMPLDETAILSREPORT'
1177: AND HOI.organization_id = p_business_group_id
1178: AND HOI.org_information3 = p_info_type
1179: AND p_effective_date BETWEEN fnd_date.canonical_to_date(HOI.org_information5)
1180: AND fnd_date.canonical_to_date(HOI.org_information6);
1181: --
1182: wrk_reg_org_add_info cur_wrk_org_add_info%ROWTYPE;
1183: --

Line 1180: AND fnd_date.canonical_to_date(HOI.org_information6);

1176: AND HOI.org_information1 = 'JPEMPLDETAILSREPORT'
1177: AND HOI.organization_id = p_business_group_id
1178: AND HOI.org_information3 = p_info_type
1179: AND p_effective_date BETWEEN fnd_date.canonical_to_date(HOI.org_information5)
1180: AND fnd_date.canonical_to_date(HOI.org_information6);
1181: --
1182: wrk_reg_org_add_info cur_wrk_org_add_info%ROWTYPE;
1183: --
1184: --Variables-----