DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_AU_EOY_VALUES_V

Line 350: from pay_au_eoy_values_v ppav,

346: Cursor checks whether any assignment exist for which Printed Payment Summary(PUI) need to be produced
347: */
348: cursor csr_is_assignemnt_exist (p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE) is
349: select count(ppav.assignment_id)
350: from pay_au_eoy_values_v ppav,
351: pay_payroll_actions ppa,
352: pay_assignment_actions pac
353: where ppa.payroll_action_id= p_payroll_action_id
354: and ppav.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)