APPS.PAY_1099R_PKG dependencies on FND_DATE

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

1008: l_procedure_name := g_package||'sort_action';
1009: hr_utility.trace('Entering :'||l_procedure_name);
1010: hr_utility.trace('Beginning of the sort_action cursor');
1011: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
1012: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
1013: ppa.legislative_parameters)),'DD-MON-YYYY')
1014: into l_effective_date, l_session_date
1015: from pay_payroll_actions ppa
1016: where payroll_action_id = payactid;

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

1419:
1420:
1421: CURSOR c_parameters (asg_actid in NUMBER) IS
1422: SELECT ppa.legislative_parameters,
1423: fnd_date.canonical_to_date(pay_1099r_pkg.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters)),
1424: pay_1099r_pkg.get_parameter('PRINT_INSTRUCTION',ppa.legislative_parameters)
1425: FROM pay_payroll_actions ppa,
1426: pay_assignment_actions paa
1427: WHERE paa.assignment_action_id = asg_actid

Line 1488: l_corrected_date := fnd_date.canonical_to_date(

1484: begin
1485:
1486: /* Code to print Amended/amended date on 1099R */
1487:
1488: l_corrected_date := fnd_date.canonical_to_date(
1489: pay_us_archive_util.get_archive_value(l_fed_aaid,
1490: 'A_ARCHIVE_DATE',
1491: l_tax_unit_id));
1492:

Line 1507: l_profile_date := fnd_date.canonical_to_date('4712/12/31');

1503: hr_utility.trace('orig 1099R Profile date'||l_live_profile_option);
1504: hr_utility.trace('1099R-l_payroll_action_id '||l_payroll_action_id);
1505:
1506: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
1507: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
1508: ELSE
1509:
1510: l_profile_date_string :=
1511: pay_us_archive_util.get_archive_value(l_payroll_action_id,

Line 1518: l_profile_date := fnd_date.canonical_to_date(l_year+1||'/'||l_live_profile_option);

1514:
1515: hr_utility.trace('l_profile_date '||l_profile_date_string);
1516:
1517: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
1518: l_profile_date := fnd_date.canonical_to_date(l_year+1||'/'||l_live_profile_option);
1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
1520: ELSE
1521: l_profile_date := fnd_date.canonical_to_date(l_profile_date_string);
1522:

Line 1521: l_profile_date := fnd_date.canonical_to_date(l_profile_date_string);

1517: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
1518: l_profile_date := fnd_date.canonical_to_date(l_year+1||'/'||l_live_profile_option);
1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
1520: ELSE
1521: l_profile_date := fnd_date.canonical_to_date(l_profile_date_string);
1522:
1523: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
1524:
1525: END IF;

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

1606:
1607: /* Get Person Address*/
1608: get_person_address(l_fed_aaid,
1609: l_eff_date,
1610: fnd_date.canonical_to_date(to_char(l_year)||'/12/31'),
1611: l_addr_line1,
1612: l_addr_line2,
1613: l_city_state_zip);
1614: