DBA Data[Home] [Help]

APPS.PAY_JP_LTAX_EFILE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 123: pay_assignment_actions paan,

119: nvl(pptn.action_information15,pptn.action_information3), pptn.action_information9, 0) sp_ltax_shi,
120: decode(pptn.action_information3,
121: nvl(pptn.action_information15,pptn.action_information3), pptn.action_information10, 0) sp_ltax_to
122: from pay_payroll_actions ppan,
123: pay_assignment_actions paan,
124: pay_action_information pptn
125: where ppan.business_group_id = g_parameter.business_group_id
126: and ppan.action_type in ('R', 'Q', 'B')
127: and ppan.effective_date

Line 151: pay_assignment_actions paal,

147: pptl.action_information8 sp_ltax_income,
148: pptl.action_information9 sp_ltax_shi,
149: pptl.action_information10 sp_ltax_to
150: from pay_payroll_actions ppal,
151: pay_assignment_actions paal,
152: pay_action_information pptl
153: where ppal.business_group_id = g_parameter.business_group_id
154: and ppal.action_type in ('R', 'Q', 'B')
155: and ppal.effective_date

Line 282: pay_assignment_actions paan2,

278: and pai.action_information21 = g_parameter.organization_id
279: and not exists(
280: select NULL
281: from pay_action_interlocks pain,
282: pay_assignment_actions paan2,
283: pay_payroll_actions ppan2
284: where pain.locked_action_id = pai.action_information1
285: and paan2.assignment_action_id = pain.locking_action_id
286: and ppan2.payroll_action_id = paan2.payroll_action_id