DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 130: FROM pay_assignment_actions paa,

126: to_char(to_date(trim(pactd.action_information24),'DD-MM-YYYY'),'DD/MM/YYYY') StartDate,
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,

Line 132: pay_assignment_actions paad,

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,
136: pay_all_payrolls_f ppf,

Line 212: FROM pay_assignment_actions paa

208: sum(to_number(pact.action_information5)) EMPR_PRSA_BAL,
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