APPS.PAY_JP_LTAX_EFILE_PKG dependencies on PAY_ACTION_INFORMATION

Line 66: l_assignment_id pay_action_information.assignment_id%TYPE;

62: --
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;

Line 124: pay_action_information pptn

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
128: between g_parameter.effective_date_from and g_parameter.effective_date_to

Line 152: pay_action_information pptl

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
156: between g_parameter.effective_date_from and g_parameter.effective_date_to

Line 274: from pay_action_information pai

270: loop
271:
272: select count(1)
273: into l_count
274: from pay_action_information pai
275: where pai.action_information_category = 'JP_PRE_TAX_1'
276: and pai.action_context_type = 'AAP'
277: and pai.action_information1 = l_rec.assignment_action_id
278: and pai.action_information21 = g_parameter.organization_id