APPS.PAY_1099R_PKG dependencies on FND_DATE

Line 996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',

992: l_procedure_name := g_package||'sort_action';
993: hr_utility.trace('Entering :'||l_procedure_name);
994: hr_utility.trace('Beginning of the sort_action cursor');
995: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
997: ppa.legislative_parameters)),'DD-MON-YYYY')
998: into l_effective_date, l_session_date
999: from pay_payroll_actions ppa
1000: where payroll_action_id = payactid;

Line 1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),

1401:
1402:
1403: CURSOR c_parameters (asg_actid in NUMBER) IS
1404: SELECT ppa.legislative_parameters,
1405: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1406: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1407: FROM pay_payroll_actions ppa,
1408: pay_assignment_actions paa
1409: WHERE paa.assignment_action_id = asg_actid

Line 1507: fnd_date.canonical_to_date(to_char(l_year)||'/12/31'),

1503:
1504: /* Get Person Address*/
1505: get_person_address(l_fed_aaid,
1506: l_eff_date,
1507: fnd_date.canonical_to_date(to_char(l_year)||'/12/31'),
1508: l_addr_line1,
1509: l_addr_line2,
1510: l_city_state_zip);
1511: