DBA Data[Home] [Help]

APPS.PAY_FI_PAYLIST dependencies on PAY_ASSIGNMENT_ACTIONS

Line 86: pay_assignment_actions paa,

82: pai_ass.action_information12 net_pay,
83: pai_ass.action_information13 capital_income_base,
84: pai_ass.action_information14 assignment_number
85: FROM pay_payroll_actions ppa,
86: pay_assignment_actions paa,
87: pay_action_information pai_ass
88: WHERE ppa.payroll_action_id = csr_v_pa_id
89: AND paa.payroll_action_id = ppa.payroll_action_id
90: AND paa.assignment_action_id = pai_ass.action_context_id

Line 114: pay_assignment_actions paa,

110: after_tax_deductions,
111: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
112: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai_ass
116: WHERE ppa.payroll_action_id = csr_v_pa_id
117: AND paa.payroll_action_id = ppa.payroll_action_id
118: AND paa.assignment_action_id = pai_ass.action_context_id