DBA Data[Home] [Help]

APPS.PAY_ZA_ACB_TAPE dependencies on PAY_ACTION_INTERLOCKS

Line 77: from pay_action_interlocks pai

73: and paa.pre_payment_id = ppp.pre_payment_id
74: and paa2.assignment_action_id =
75: (
76: select max(locked_action_id)
77: from pay_action_interlocks pai
78: where pai.locking_action_id = ppp.assignment_action_id
79: )
80: and paa2.payroll_action_id = ppa2.payroll_action_id
81: and ppa2.payroll_id = ppf.payroll_id

Line 146: from pay_action_interlocks pai

142: and ppm.external_account_id = pea2.external_account_id
143: and paa2.assignment_action_id =
144: (
145: select max(locked_action_id)
146: from pay_action_interlocks pai
147: where pai.locking_action_id = ppp.assignment_action_id
148: )
149: and paa2.payroll_action_id = ppa2.payroll_action_id
150: and ppa2.time_period_id = ptp.time_period_id