[Home] [Help]
108: ,asg.assignment_id
109: ,paa.assignment_action_id
110: FROM per_assignments_f asg
111: ,pay_assignment_actions paa
112: ,pay_payroll_actions ppa
113: ,hr_soft_coding_keyflex hscl
114: ,per_people_f ppf
115: WHERE asg.assignment_id = paa.assignment_id
116: AND paa.payroll_action_id = ppa.payroll_action_id
128:
129: /* Cursor to fetch first assignment_action_id and date earned for the employee */
130: CURSOR csr_get_first_assact (l_assignment_id number,l_date date) IS
131: select decode(trunc(ppa.date_earned,'YYYY'),trunc(l_date,'YYYY'),trunc(l_date,'YYYY'),ppa.date_earned) , paa.assignment_action_id
132: from pay_payroll_actions ppa, pay_assignment_actions paa
133: Where paa.assignment_id = l_assignment_id
134: and paa.payroll_action_id = ppa.payroll_action_id
135: and ppa.action_type in ('R','Q')
136: and ppa.action_status = 'C'
193:
194: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE SOCIAL ALLOWANCE */
195: CURSOR csr_get_assact_first (l_assignment_id number,l_date date) IS
196: select ppa.date_earned, paa.assignment_action_id
197: from pay_payroll_actions ppa, pay_assignment_actions paa
198: Where paa.assignment_id = l_assignment_id
199: and paa.payroll_action_id = ppa.payroll_action_id
200: and ppa.action_type in ('R','Q')
201: and ppa.action_status = 'C'
205:
206: /* Cursor to fetch assignment_action_id corresponding to first_date_earned to calculate social allowance */
207: CURSOR csr_get_assact_one (l_assignment_id number,l_date date) IS
208: select paa.assignment_action_id
209: from pay_payroll_actions ppa, pay_assignment_actions paa
210: Where paa.assignment_id = l_assignment_id
211: and paa.payroll_action_id = ppa.payroll_action_id
212: and ppa.action_type in ('R','Q')
213: and ppa.action_status = 'C'
735: ,paa.assignment_action_id
736: ,ppa.date_earned
737: FROM per_assignments_f asg
738: ,pay_assignment_actions paa
739: ,pay_payroll_actions ppa
740: ,hr_soft_coding_keyflex hscl
741: ,per_people_f ppf
742: WHERE asg.assignment_id = paa.assignment_id
743: AND paa.payroll_action_id = ppa.payroll_action_id
760: ,paa.assignment_action_id
761: ,ppa.date_earned
762: FROM per_assignments_f asg
763: ,pay_assignment_actions paa
764: ,pay_payroll_actions ppa
765: ,hr_soft_coding_keyflex hscl
766: ,per_people_f ppf
767: WHERE asg.assignment_id = p_assignment_id
768: AND asg.assignment_id = paa.assignment_id
791:
792: /* Cursor to fetch assignment_action_ids and date earned for the employee */
793: CURSOR csr_get_assact (l_assignment_id number,l_date date) IS
794: select ppa.date_earned, paa.assignment_action_id
795: from pay_payroll_actions ppa, pay_assignment_actions paa
796: Where paa.assignment_id = l_assignment_id
797: and paa.payroll_action_id = ppa.payroll_action_id
798: and ppa.action_type in ('R','Q')
799: and ppa.action_status = 'C'
1396: ,ppa.date_earned
1397: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1398: FROM per_assignments_f asg
1399: ,pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,hr_soft_coding_keyflex hscl
1402: ,per_periods_of_service pos
1403: ,per_people_f ppf
1404: WHERE asg.assignment_id = paa.assignment_id
1465:
1466: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE LAST SALARY DATE */
1467: CURSOR csr_get_assact_de (l_assignment_id number,l_date date) IS
1468: select ppa.date_earned, paa.assignment_action_id
1469: from pay_payroll_actions ppa, pay_assignment_actions paa
1470: Where paa.assignment_id = l_assignment_id
1471: and paa.payroll_action_id = ppa.payroll_action_id
1472: and ppa.action_type in ('R','Q')
1473: and ppa.action_status = 'C'
1477:
1478: /* Cursor to fetch assignment_action_ids and date earned for the employee TO CAPTURE SOCIAL ALLOWANCE */
1479: CURSOR csr_get_assact_first (l_assignment_id number,l_date date) IS
1480: select ppa.date_earned, paa.assignment_action_id
1481: from pay_payroll_actions ppa, pay_assignment_actions paa
1482: Where paa.assignment_id = l_assignment_id
1483: and paa.payroll_action_id = ppa.payroll_action_id
1484: and ppa.action_type in ('R','Q')
1485: and ppa.action_status = 'C'
1489:
1490: /* Cursor to fetch assignment_action_id corresponding to first_date_earned to calculate social allowance */
1491: CURSOR csr_get_assact_one (l_assignment_id number,l_date date) IS
1492: select paa.assignment_action_id
1493: from pay_payroll_actions ppa, pay_assignment_actions paa
1494: Where paa.assignment_id = l_assignment_id
1495: and paa.payroll_action_id = ppa.payroll_action_id
1496: and ppa.action_type in ('R','Q')
1497: and ppa.action_status = 'C'
1611:
1612: /* Cursor to fetch assignment_action_id and date_earned if Employee is the parameter */
1613: CURSOR csr_get_emp_assact_data (l_assignment_id number,l_date date) IS
1614: select paa.assignment_action_id , ppa.date_earned
1615: from pay_payroll_actions ppa, pay_assignment_actions paa
1616: Where paa.assignment_id = l_assignment_id
1617: and paa.payroll_action_id = ppa.payroll_action_id
1618: and ppa.action_type in ('R','Q')
1619: and ppa.action_status = 'C'
1622:
1623: /* Cursor to fetch last sal date */
1624: CURSOR csr_get_last_sal_date(l_assignment_id number , l_date date) IS
1625: SELECT min(ppa.date_earned)
1626: FROM pay_payroll_actions ppa, pay_assignment_actions paa
1627: WHERE paa.assignment_id = l_assignment_id
1628: AND paa.payroll_action_id = ppa.payroll_action_id
1629: and ppa.action_type in ('R','Q')
1630: and ppa.action_status = 'C'