[Home] [Help]
42:
43: -- Variables needed for the report
44: l_sum NUMBER;
45:
46: l_payroll_action_id pay_action_information.action_information1%TYPE;
47: l_sr_no NUMBER ;
48: l_counter number := 0;
49: CURSOR CSR_HEADER(csr_v_pa_id IN VARCHAR2)
50: IS
53: payment_month,
54: pai.action_information6 pay_day,
55: pai.action_information7
56: end_date
57: FROM pay_action_information pai,
58: pay_payroll_actions ppa
59: WHERE pai.action_context_id = ppa.payroll_action_id
60: AND ppa.payroll_action_id = csr_v_pa_id;
61: CSR_HEADER_REC CSR_HEADER%ROWTYPE;
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
91: AND pai_ass.action_context_type = 'AAP'
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
119: AND pai_ass.action_context_type = 'AAP'