DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on PAY_ACTION_INTERLOCKS

Line 110: FROM pay_action_interlocks pail

106: and pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES' --3098353
107: and pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', ppac.assignment_action_id)='NO' --3937976
108: and not exists
109: (select locked_action_id
110: FROM pay_action_interlocks pail
111: WHERE pail.locked_action_id=ppac.assignment_action_id)
112: and ppac.assignment_action_id in
113: (select max(ppac1.assignment_action_id)
114: from pay_assignment_actions ppac1,

Line 184: FROM pay_action_interlocks pail

180: AND pay_core_utils.get_parameter('REGISTERED_EMPLOYER', pmpa.legislative_parameters) = c_reg_emp
181: AND pay_core_utils.get_parameter('FINANCIAL_YEAR', pmpa.legislative_parameters) = c_financial_year
182: AND NOT EXISTS
183: (SELECT locked_action_id
184: FROM pay_action_interlocks pail
185: WHERE pail.locked_action_id=ppac.assignment_action_id)
186: AND ppac.assignment_action_id IN
187: (SELECT MAX(ppac1.assignment_action_id)
188: FROM pay_assignment_actions ppac1,