DBA Data[Home] [Help]

APPS.PAY_US_FLS_REPORTING_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 390: from pay_action_interlocks pai,

386: and paf.effective_end_date
387: and not exists
388: (select /*+ ORDERED */
389: ''x''
390: from pay_action_interlocks pai,
391: pay_assignment_actions paa1,
392: pay_payroll_actions ppa1
393: where pai.locked_action_id = paa.assignment_action_id
394: and paa1.assignment_action_id = pai.locking_action_id

Line 469: from pay_action_interlocks pai,

465: and paf.effective_end_date
466: and not exists
467: (select /*+ ORDERED */
468: 'x'
469: from pay_action_interlocks pai,
470: pay_assignment_actions paa1,
471: pay_payroll_actions ppa1
472: where pai.locked_action_id = paa.assignment_action_id
473: and paa1.assignment_action_id = pai.locking_action_id