DBA Data[Home] [Help]

APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PAY_ELEMENT_TYPES_V1

Line 8: from pay_element_types_v1

4: procedure total_payment (p_assignment_action_id in number,
5: p_total_payment out nocopy number) is
6:
7: cursor csr_payment is select sum(result_value)
8: from pay_element_types_v1
9: where classification_name in ('Normal Income','Allowances',
10: 'Direct Payments','Lump Sum Amounts')
11: and p_assignment_action_id = assignment_action_id;
12: begin

Line 27: from pay_element_types_v1

23: ------------------------------------------------------------------------------
24: procedure total_deduct (p_assignment_action_id in number,
25: p_total_deduct out nocopy number) is
26: cursor csr_deduct is select sum(result_value)
27: from pay_element_types_v1
28: where classification_name in ('Statutory Deductions', 'Deductions',
29: 'Involuntary Deductions','Voluntary Deductions')
30: and p_assignment_action_id = assignment_action_id;
31: begin