APPS.PAY_JP_LTAX_EFILE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 67: l_date_earned pay_payroll_actions.date_earned%TYPE;

63: l_district_code VARCHAR2(255);
64: l_district_name_kana VARCHAR2(255);
65: l_swot_number VARCHAR2(255);
66: l_assignment_id pay_action_information.assignment_id%TYPE;
67: l_date_earned pay_payroll_actions.date_earned%TYPE;
68: l_ltax NUMBER;
69: l_ltax_lumpsum NUMBER;
70: l_sp_ltax NUMBER;
71: l_sp_ltax_income NUMBER;

Line 122: from pay_payroll_actions ppan,

118: decode(pptn.action_information3,
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')

Line 150: from pay_payroll_actions ppal,

146: pptl.action_information7 sp_ltax,
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')

Line 283: pay_payroll_actions ppan2

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
287: and ppan2.action_type = 'V');