DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_PAYWSMEE_PKG

Line 4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,

4255: */
4256: CURSOR archive_retro_elements ( cp_element_entry_id in number ,
4257: cp_run_assignment_action_id in number ) IS
4258:
4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4260: fnd_date.date_to_canonical(ptp.start_date),
4261: fnd_date.date_to_canonical(ptp.end_date),
4262: hr_general.decode_lookup
4263: (DECODE (UPPER (ec.classification_name),

Line 4286: AND pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)

4282: AND et.classification_id = ec.classification_id
4283: AND paa.assignment_action_id = cp_run_assignment_action_id
4284: AND ppa.payroll_action_id = paa.payroll_action_id
4285: AND ptp.payroll_id = ppa.payroll_id
4286: AND pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)
4287: BETWEEN ptp.start_date
4288: AND ptp.end_date ;
4289:
4290: CURSOR get_element_entry_id(cp_run_action_id in number ,