APPS.PAY_IE_P35_XML_PKG dependencies on PAY_ACTION_INFORMATION

Line 133: pay_action_information pactd,

129: pactd.action_information27
130: FROM pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_assignment_actions paad,
133: pay_action_information pactd,
134: pay_action_information pai,
135: per_assignments_f paaf,
136: pay_all_payrolls_f ppf,
137: hr_soft_coding_keyflex flex

Line 134: pay_action_information pai,

130: FROM pay_assignment_actions paa,
131: pay_payroll_actions ppa,
132: pay_assignment_actions paad,
133: pay_action_information pactd,
134: pay_action_information pai,
135: per_assignments_f paaf,
136: pay_all_payrolls_f ppf,
137: hr_soft_coding_keyflex flex
138: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 213: ,pay_action_information pact

209: count(decode(pact.action_information6,0,null,null,null,1)) EMP_RAC,
210: sum(to_number(pact.action_information6)) EMP_RAC_BAL,
211: sum(to_number(pact.action_information1)) TAXABLEBENEFITS
212: FROM pay_assignment_actions paa
213: ,pay_action_information pact
214: WHERE paa.payroll_action_id = p_payroll_action_id
215: and paa.assignment_action_id = pact.action_context_id
216: and paa.assignment_action_id = p_assignment_action_id
217: and paa.source_action_id is null

Line 237: ,pay_action_information pact

233: decode(trim(p_weeks),'Y','1','0'),
234: 'Oracle HRMS',
235: 'E'
236: FROM pay_payroll_actions ppa
237: ,pay_action_information pact
238: WHERE ppa.payroll_action_id = p_payroll_action_id
239: AND pact.action_context_id = ppa.payroll_action_id
240: AND pact.action_information_category = 'ADDRESS DETAILS'
241: AND pact.action_context_type = 'PA';

Line 277: l_initial_class pay_action_information.action_information4%TYPE;

273: l_taxable_benefits NUMBER := 0;
274: flag NUMBER := 0;
275: c_pension csr_get_pension_details%ROWTYPE;
276: l_cess_date VARCHAR2(30);
277: l_initial_class pay_action_information.action_information4%TYPE;
278:
279: BEGIN
280:
281: