DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on PAY_GB_PAY_VALUES_V

Line 248: from pay_gb_pay_values_v

244: -- as conversion already handled in view, and extra call causes problems in
245: -- calculation when working in non-GB environment
246: cursor csr_payment is
247: select sum(result_value)
248: from pay_gb_pay_values_v
249: where base_classification_name in ('Earnings','Direct Net', 'Direct Payment')
250: and p_assignment_action_id = assignment_action_id;
251: --
252: begin

Line 269: from pay_gb_pay_values_v

265: -- Bug 2553453, removed call to fnd_number.canonical_to_number from query
266: -- as conversion already handled in view, and extra call causes problems in
267: -- calculation when working in non-GB environment
268: cursor csr_deduct is select sum(result_value)
269: from pay_gb_pay_values_v
270: where base_classification_name in
271: ('Pre Statutory', 'Statutory', 'Court Orders',
272: 'Pre Tax Deductions','PAYE','NI','Voluntary Deductions',
273: 'Pre NI Deductions','Pre Tax and NI Deductions')