DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 399: from pay_action_interlocks pai,

395: and paf.effective_end_date
396: and not exists
397: (select /*+ ORDERED */
398: ''x''
399: from pay_action_interlocks pai,
400: pay_assignment_actions paa1,
401: pay_payroll_actions ppa1
402: where pai.locked_action_id = paa.assignment_action_id
403: and paa1.assignment_action_id = pai.locking_action_id

Line 478: from pay_action_interlocks pai,

474: and paf.effective_end_date
475: and not exists
476: (select /*+ ORDERED */
477: 'x'
478: from pay_action_interlocks pai,
479: pay_assignment_actions paa1,
480: pay_payroll_actions ppa1
481: where pai.locked_action_id = paa.assignment_action_id
482: and paa1.assignment_action_id = pai.locking_action_id