DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FND_DATE

Line 228: the 11i fnd_date and fnd_number changes

224: c_rts_dup_wage cursor. This SQL was
225: changed due to Fidelity performance
226: problem.
227: 12-JUN-2000 asasthan 115.5 update till Q2 2000 changes and includes
228: the 11i fnd_date and fnd_number changes
229: 22-MAY-2000 ashgupta 40.12 1237099 Added the error messages in the
230: preprocess_check function
231: 02-MAR-2000 rpotnuru 40.11 1220213 Terminated Employees not showing for $th Qtr
232: NY sqwl. Range cursor date range will now the whole

Line 3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));

3201:
3202: /* Setup contexts */
3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:
3209: /* Get the year begin and year end dates */

Line 3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */

3202: /* Setup contexts */
3203:
3204: pay_balance_pkg.set_context ('ASSIGNMENT_ID', asgid);
3205: pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned));
3206: /* pay_balance_pkg.set_context ('DATE_EARNED',fnd_date.date_to_canonical(date_earned,'DD-MON-YYYY')); date format not required */
3207: pay_balance_pkg.set_context ('TAX_UNIT_ID', taxunitid);
3208:
3209: /* Get the year begin and year end dates */
3210: