DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_PKG dependencies on FND_DATE

Line 1131: l_virtual_date :=fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_virtual_date));

1127: l_tax_balance_category := p_tax_balance_category;
1128: --
1129: -- Check if assignment exists at l_virtual_date, if using date mode
1130: -- Changed date format to DD-MON-YYYY, bug 612696
1131: l_virtual_date :=fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_virtual_date));
1132: --
1133: hr_utility.set_location('pay_tax_bals_pkg',50);
1134: --
1135: IF (l_assignment_id is not null and l_virtual_date is not null) THEN

Line 1345: fnd_date.date_to_canonical(l_virtual_date));

1341: l_found boolean;
1342: check_asg number;
1343: begin
1344: pay_balance_pkg.set_context('DATE_EARNED',
1345: fnd_date.date_to_canonical(l_virtual_date));
1346: pay_balance_pkg.set_context('BALANCE_DATE',
1347: fnd_date.date_to_canonical(l_virtual_date));
1348: select business_group_id
1349: into l_bg_id

Line 1347: fnd_date.date_to_canonical(l_virtual_date));

1343: begin
1344: pay_balance_pkg.set_context('DATE_EARNED',
1345: fnd_date.date_to_canonical(l_virtual_date));
1346: pay_balance_pkg.set_context('BALANCE_DATE',
1347: fnd_date.date_to_canonical(l_virtual_date));
1348: select business_group_id
1349: into l_bg_id
1350: from hr_organization_units
1351: where organization_id = p_gre_id_context;