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 224: ,pay_action_information pact

220: sum(to_number(pact.action_information28)) EXCLUSIONORDER
221: --12382953
222: ,sum(to_number(pact.action_information22)) EMP_IB --14656910
223: FROM pay_assignment_actions paa
224: ,pay_action_information pact
225: WHERE paa.payroll_action_id = p_payroll_action_id
226: and paa.assignment_action_id = pact.action_context_id
227: and paa.assignment_action_id = p_assignment_action_id
228: and paa.source_action_id is null

Line 248: ,pay_action_information pact

244: decode(trim(p_weeks),'Y','1','0'),
245: 'Oracle HRMS',
246: 'E'
247: FROM pay_payroll_actions ppa
248: ,pay_action_information pact
249: WHERE ppa.payroll_action_id = p_payroll_action_id
250: AND pact.action_context_id = ppa.payroll_action_id
251: AND pact.action_information_category = 'ADDRESS DETAILS'
252: AND pact.action_context_type = 'PA';

Line 292: l_initial_class pay_action_information.action_information4%TYPE;

288: l_emp_income_levy_bal NUMBER := 0;
289: l_emp_gross_income_bal NUMBER := 0;
290: c_pension csr_get_pension_details%ROWTYPE;
291: l_cess_date VARCHAR2(30);
292: l_initial_class pay_action_information.action_information4%TYPE;
293:
294: --12382953
295: l_emp_usc_bal NUMBER := 0;
296: l_emp_gross_income_bal_usc NUMBER := 0;