DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_AU_EOY_VALUES_V

Line 607: from pay_au_eoy_values_v ppav,

603: Cursor checks whether any assignment exist for which Printed Payment Summary(PUI) need to be produced
604: */
605: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is
606: select count(ppav.assignment_id)
607: from pay_au_eoy_values_v ppav,
608: pay_payroll_actions ppa,
609: pay_assignment_actions pac
610: where ppa.payroll_action_id= p_payroll_action_id
611: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)