DBA Data[Home] [Help]

APPS.PAY_QPQ_API dependencies on FND_NUMBER

Line 484: open cur_dat(fnd_number.canonical_to_number(p_assignment_id), fnd_date.canonical_to_date(p_new_date));

480: --
481: -- Check that the assignment is on a payroll as of
482: -- the proposed effective date
483: --
484: open cur_dat(fnd_number.canonical_to_number(p_assignment_id), fnd_date.canonical_to_date(p_new_date));
485: fetch cur_dat into v_exists;
486: if cur_dat%notfound then
487: close cur_dat;
488: -- Error: You cannot change to this effective date, because the current

Line 4492: select fnd_number.canonical_to_number(parameter_value)

4488: from pay_payroll_actions
4489: where payroll_action_id = p_payroll_action_id;
4490: --
4491: cursor cur_max is
4492: select fnd_number.canonical_to_number(parameter_value)
4493: from pay_action_parameters
4494: where parameter_name = 'QUICKPAY_MAX_WAIT_SEC';
4495: --
4496: cursor cur_intw is

Line 4497: select fnd_number.canonical_to_number(parameter_value)

4493: from pay_action_parameters
4494: where parameter_name = 'QUICKPAY_MAX_WAIT_SEC';
4495: --
4496: cursor cur_intw is
4497: select fnd_number.canonical_to_number(parameter_value)
4498: from pay_action_parameters
4499: where parameter_name = 'QUICKPAY_INTERVAL_WAIT_SEC';
4500: --
4501: begin