DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 131: pay_payroll_actions ppa,

127: decode(to_char(to_date(trim(pactd.action_information25),'DD-MM-YYYY'),'DD/MM/YYYY'),'31/12/4712',null,to_char(to_date(trim(pactd.action_information25),'DD-MM-YYYY'),'DD/MM/YYYY')) EndDate,
128: pactd.action_information26 Credit,
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,

Line 247: FROM pay_payroll_actions ppa

243: pact.action_information7 ,
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'