[Home] [Help]
93: ,asg.assignment_id
94: ,paa.assignment_action_id
95: FROM per_assignments_f asg
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,hr_soft_coding_keyflex hscl
99: ,per_people_f ppf
100: WHERE asg.assignment_id = paa.assignment_id
101: AND paa.payroll_action_id = ppa.payroll_action_id
113:
114: /* Cursor to fetch first assignment_action_id and date earned for the employee */
115: CURSOR csr_get_first_assact (l_assignment_id number,l_date date) IS
116: select decode(trunc(ppa.date_earned,'YYYY'),trunc(l_date,'YYYY'),trunc(l_date,'YYYY'),ppa.date_earned) , paa.assignment_action_id
117: from pay_payroll_actions ppa, pay_assignment_actions paa
118: Where paa.assignment_id = l_assignment_id
119: and paa.payroll_action_id = ppa.payroll_action_id
120: and ppa.action_type in ('R','Q')
121: and ppa.action_status = 'C'
178:
179: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE SOCIAL ALLOWANCE */
180: CURSOR csr_get_assact_first (l_assignment_id number,l_date date) IS
181: select ppa.date_earned, paa.assignment_action_id
182: from pay_payroll_actions ppa, pay_assignment_actions paa
183: Where paa.assignment_id = l_assignment_id
184: and paa.payroll_action_id = ppa.payroll_action_id
185: and ppa.action_type in ('R','Q')
186: and ppa.action_status = 'C'
190:
191: /* Cursor to fetch assignment_action_id corresponding to first_date_earned to calculate social allowance */
192: CURSOR csr_get_assact_one (l_assignment_id number,l_date date) IS
193: select paa.assignment_action_id
194: from pay_payroll_actions ppa, pay_assignment_actions paa
195: Where paa.assignment_id = l_assignment_id
196: and paa.payroll_action_id = ppa.payroll_action_id
197: and ppa.action_type in ('R','Q')
198: and ppa.action_status = 'C'
677: ,paa.assignment_action_id
678: ,ppa.date_earned
679: FROM per_assignments_f asg
680: ,pay_assignment_actions paa
681: ,pay_payroll_actions ppa
682: ,hr_soft_coding_keyflex hscl
683: ,per_people_f ppf
684: WHERE asg.assignment_id = paa.assignment_id
685: AND paa.payroll_action_id = ppa.payroll_action_id
702: ,paa.assignment_action_id
703: ,ppa.date_earned
704: FROM per_assignments_f asg
705: ,pay_assignment_actions paa
706: ,pay_payroll_actions ppa
707: ,hr_soft_coding_keyflex hscl
708: ,per_people_f ppf
709: WHERE asg.assignment_id = p_assignment_id
710: AND asg.assignment_id = paa.assignment_id
733:
734: /* Cursor to fetch assignment_action_ids and date earned for the employee */
735: CURSOR csr_get_assact (l_assignment_id number,l_date date) IS
736: select ppa.date_earned, paa.assignment_action_id
737: from pay_payroll_actions ppa, pay_assignment_actions paa
738: Where paa.assignment_id = l_assignment_id
739: and paa.payroll_action_id = ppa.payroll_action_id
740: and ppa.action_type in ('R','Q')
741: and ppa.action_status = 'C'
1338: ,ppa.date_earned
1339: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1340: FROM per_assignments_f asg
1341: ,pay_assignment_actions paa
1342: ,pay_payroll_actions ppa
1343: ,hr_soft_coding_keyflex hscl
1344: ,per_periods_of_service pos
1345: ,per_people_f ppf
1346: WHERE asg.assignment_id = paa.assignment_id
1407:
1408: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE LAST SALARY DATE */
1409: CURSOR csr_get_assact_de (l_assignment_id number,l_date date) IS
1410: select ppa.date_earned, paa.assignment_action_id
1411: from pay_payroll_actions ppa, pay_assignment_actions paa
1412: Where paa.assignment_id = l_assignment_id
1413: and paa.payroll_action_id = ppa.payroll_action_id
1414: and ppa.action_type in ('R','Q')
1415: and ppa.action_status = 'C'
1419:
1420: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE SOCIAL ALLOWANCE */
1421: CURSOR csr_get_assact_first (l_assignment_id number,l_date date) IS
1422: select ppa.date_earned, paa.assignment_action_id
1423: from pay_payroll_actions ppa, pay_assignment_actions paa
1424: Where paa.assignment_id = l_assignment_id
1425: and paa.payroll_action_id = ppa.payroll_action_id
1426: and ppa.action_type in ('R','Q')
1427: and ppa.action_status = 'C'
1431:
1432: /* Cursor to fetch assignment_action_id corresponding to first_date_earned to calculate social allowance */
1433: CURSOR csr_get_assact_one (l_assignment_id number,l_date date) IS
1434: select paa.assignment_action_id
1435: from pay_payroll_actions ppa, pay_assignment_actions paa
1436: Where paa.assignment_id = l_assignment_id
1437: and paa.payroll_action_id = ppa.payroll_action_id
1438: and ppa.action_type in ('R','Q')
1439: and ppa.action_status = 'C'
1553:
1554: /* Cursor to fetch assignment_action_id and date_earned if Employee is the parameter */
1555: CURSOR csr_get_emp_assact_data (l_assignment_id number,l_date date) IS
1556: select paa.assignment_action_id , ppa.date_earned
1557: from pay_payroll_actions ppa, pay_assignment_actions paa
1558: Where paa.assignment_id = l_assignment_id
1559: and paa.payroll_action_id = ppa.payroll_action_id
1560: and ppa.action_type in ('R','Q')
1561: and ppa.action_status = 'C'
1564:
1565: /* Cursor to fetch last sal date */
1566: CURSOR csr_get_last_sal_date(l_assignment_id number , l_date date) IS
1567: SELECT min(ppa.date_earned)
1568: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1569: WHERE paa.assignment_id = l_assignment_id
1570: AND paa.payroll_action_id = ppa.payroll_action_id
1571: and ppa.action_type in ('R','Q')
1572: and ppa.action_status = 'C'