DBA Data[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_PAYWSMEE_PKG

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

4749: */
4750: CURSOR archive_retro_elements ( cp_element_entry_id in number ,
4751: cp_run_assignment_action_id in number ) IS
4752:
4753: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4754: fnd_date.date_to_canonical(ptp.start_date),
4755: fnd_date.date_to_canonical(ptp.end_date),
4756: hr_general.decode_lookup
4757: (DECODE (UPPER (ec.classification_name),

Line 4780: AND pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)

4776: AND et.classification_id = ec.classification_id
4777: AND paa.assignment_action_id = cp_run_assignment_action_id
4778: AND ppa.payroll_action_id = paa.payroll_action_id
4779: AND ptp.payroll_id = ppa.payroll_id
4780: AND pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)
4781: BETWEEN ptp.start_date
4782: AND ptp.end_date
4783: /*Bug# 16318258 - Start */
4784: AND NVL(ppa.date_earned, ppa.effective_date) BETWEEN peef.effective_start_date AND