DBA Data[Home] [Help]

APPS.PAY_JP_REPORT_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 899: from pay_action_interlocks pai2,

895: and ppa.effective_date between pa.effective_start_date and pa.effective_end_date
896: --
897: and not exists(
898: select NULL /* Removed the hint as per Bug# 5033800 */
899: from pay_action_interlocks pai2,
900: pay_assignment_actions paa2,
901: pay_payroll_actions ppa2
902: where pai2.locked_action_id = paa.assignment_action_id
903: and paa2.assignment_action_id = pai2.locking_action_id