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 223: FROM pay_assignment_actions paa

219: sum(to_number(pact.action_information27)) EMP_GROSS_INCOME_USC,
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