[Home] [Help]
48:
49: /* Cursor to fetch date_earned for the payroll action */
50: CURSOR csr_get_DE (l_pact_id number) IS
51: SELECT effective_date
52: FROM pay_payroll_actions
53: WHERE payroll_action_id = l_pact_id;
54:
55: /* Cursor to fetch payroll_name for the payroll action */
56: CURSOR csr_get_PY (l_pact_id number) IS
54:
55: /* Cursor to fetch payroll_name for the payroll action */
56: CURSOR csr_get_PY (l_pact_id number) IS
57: SELECT payroll_name
58: FROM pay_all_payrolls_f pap, pay_payroll_actions ppa
59: WHERE ppa.payroll_action_id = l_pact_id
60: AND ppa.payroll_id = pap.payroll_id;
61:
62: /* Cursor for fetching assignment action id and assignment id for current payroll action id */
69: from pay_assignment_actions paa
70: where paa.payroll_action_id = p_pact_id
71: and paa.action_status = 'C'
72: and not exists ( select 1
73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
74: where lck.locked_action_id = paa.assignment_action_id
75: and lck.locking_action_id = paa1.assignment_action_id
76: and ppa1.payroll_action_id = paa1.payroll_action_id
77: and ppa1.action_type = 'D'
87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
88: where paa.payroll_action_id = p_pact_id
89: and paa.action_status = 'C'
90: and not exists ( select 1
91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
92: where lck.locked_action_id = paa.assignment_action_id
93: and lck.locking_action_id = paa1.assignment_action_id
94: and ppa1.payroll_action_id = paa1.payroll_action_id
95: and ppa1.action_type = 'D'
110: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
111: where paa.payroll_action_id = p_pact_id
112: and paa.action_status = 'C'
113: and not exists ( select 1
114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
115: where lck.locked_action_id = paa.assignment_action_id
116: and lck.locking_action_id = paa1.assignment_action_id
117: and ppa1.payroll_action_id = paa1.payroll_action_id
118: and ppa1.action_type = 'D'
127: /*** ORDER BY PAYDATE ***/
128: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by payment date*/
129: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
130: select paa.assignment_action_id , paa.assignment_id
131: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status IN ('C','S')
135: and not exists ( select 1
132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status IN ('C','S')
135: and not exists ( select 1
136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
137: where lck.locked_action_id = paa.assignment_action_id
138: and lck.locking_action_id = paa1.assignment_action_id
139: and ppa1.payroll_action_id = paa1.payroll_action_id
140: and ppa1.action_type = 'D'
197:
198: /* Cursor for fetching the payment date of the pre payment for cheques */
199: CURSOR csr_pay_date (l_assact_id number) IS
200: select nvl(ppa.date_earned,ppa.effective_date)
201: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
202: where paa.assignment_action_id = l_assact_id
203: and paa.action_status IN ('C','S')
204: and paa.pre_payment_id = ppp.pre_payment_id
205: and ppp.assignment_action_id = paa1.assignment_action_id