[Home] [Help]
158: /* SELECTS ORGANIZATIONS COMING UNDER A PAYROLL */
159: CURSOR csr_get_orgs_for_payroll (l_payroll_id number , l_effective_date date) is
160: SELECT distinct pai_emp.action_information15 organization
161: ,ppf.payroll_id
162: FROM per_time_periods ptp
163: ,pay_action_information pai_emp
164: ,pay_assignment_actions paa1
165: ,pay_action_interlocks lck
166: ,pay_payroll_actions ppa1
181: /* CURSOR ONE */
182: cursor csr_condition_one(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
183: SELECT distinct pai_emp.action_information15 organization
184: ,ppf.payroll_id
185: FROM per_time_periods ptp
186: ,pay_action_information pai_emp
187: ,pay_assignment_actions paa1
188: ,pay_action_interlocks lck
189: ,pay_payroll_actions ppa1
214: from sys.dual) ;
215: cursor csr_condition_two(l_organization_id number , l_effective_date date) is
216: SELECT distinct pai_emp.action_information15 organization
217: ,ppf.payroll_id
218: FROM per_time_periods ptp
219: ,pay_action_information pai_emp
220: ,pay_assignment_actions paa1
221: ,pay_action_interlocks lck
222: ,pay_payroll_actions ppa1
236: AND pai_emp.action_information2 = l_organization_id;
237: cursor csr_condition_three(l_effective_date date) is
238: SELECT distinct pai_emp.action_information15 organization
239: ,ppf.payroll_id
240: FROM per_time_periods ptp
241: ,pay_action_information pai_emp
242: ,pay_assignment_actions paa1
243: ,pay_action_interlocks lck
244: ,pay_payroll_actions ppa1
258: AND 1 = 2;
259: /* CURSOR TO GET PAYROLL IDS DISTINCT */
260: cursor csr_distinct_pyrl(l_organization_id number ,l_org_structure_version_id number,l_parent_id number, l_effective_date date ) is
261: SELECT distinct ppf.payroll_id
262: FROM per_time_periods ptp
263: ,pay_action_information pai_emp
264: ,pay_assignment_actions paa1
265: ,pay_action_interlocks lck
266: ,pay_payroll_actions ppa1
291: from sys.dual) ;
292: /* CURSOR TO GET PAYROLL IDS DISTINCT FOR ORGANIZATION */
293: cursor csr_org_only_distinct_pyrl(l_organization_id number , l_effective_date date) is
294: SELECT distinct ppf.payroll_id
295: FROM per_time_periods ptp
296: ,pay_action_information pai_emp
297: ,pay_assignment_actions paa1
298: ,pay_action_interlocks lck
299: ,pay_payroll_actions ppa1
337: ,pai_emp1.action_information11
338: ,ppf.payroll_name
339: ,nvl(pai_emp1.action_information13,0) ytd_earning
340: ,nvl(pai_emp1.action_information4,0) ytd_deduction
341: FROM per_time_periods ptp
342: ,pay_action_information pai_emp
343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
498: AND pay_v.action_context_id = paa.assignment_action_id
499: AND pay_v.narrative = pai_ele.action_information4
500: AND pay_v.payment_type NOT IN ('F')
501: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
502: FROM per_time_periods ptp
503: ,pay_action_information pai_emp
504: ,pay_assignment_actions paa1
505: ,pay_action_interlocks lck
506: ,pay_payroll_actions ppa1
529: AND pay_v.action_context_id = paa.assignment_action_id
530: AND pay_v.narrative = pai_ele.action_information4
531: AND pay_v.payment_type NOT IN ('F')
532: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
533: FROM per_time_periods ptp
534: ,pay_action_information pai_emp
535: ,pay_assignment_actions paa1
536: ,pay_action_interlocks lck
537: ,pay_payroll_actions ppa1
560: CURSOR csr_get_sum_earn_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
561: --*******Fixed during performance bugs*****
562: SELECT sum(pay_v.numeric_value)
563: FROM pay_assignment_actions paa
564: ,per_time_periods ptp
565: ,pay_assignment_actions paa1
566: ,pay_action_interlocks lck
567: ,pay_payroll_actions ppa1
568: ,pay_action_information pai_ele
593: */
594:
595: CURSOR csr_seoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
596: select pai_emp.action_context_id arch_assact
597: from per_time_periods ptp
598: ,pay_action_information pai_emp
599: ,pay_assignment_actions paa1
600: ,pay_action_interlocks lck
601: ,pay_payroll_actions ppa1
644: AND pay_v.action_context_id = paa.assignment_action_id
645: AND pay_v.narrative = pai_ele.action_information4
646: AND pay_v.payment_type NOT IN ('F')
647: AND paa.assignment_action_id in (SELECT pai_emp.action_context_id arch_assact
648: FROM per_time_periods ptp
649: ,pay_action_information pai_emp
650: ,pay_assignment_actions paa1
651: ,pay_action_interlocks lck
652: ,pay_payroll_actions ppa1
675: CURSOR csr_get_sum_ded_only_org (l_organization_id number , l_payroll_id number , l_effective_date date) IS
676: --******* Fixed during performance bugs*******
677: SELECT sum(pay_v.numeric_value)
678: FROM pay_assignment_actions paa
679: ,per_time_periods ptp
680: ,pay_assignment_actions paa1
681: ,pay_action_interlocks lck
682: ,pay_payroll_actions ppa1
683: ,pay_action_information pai_ele
708: */
709:
710: CURSOR csr_sdoo_split_1 (l_organization_id number , l_payroll_id number , l_effective_date date) IS
711: select pai_emp.action_context_id arch_assact
712: from per_time_periods ptp
713: ,pay_action_information pai_emp
714: ,pay_assignment_actions paa1
715: ,pay_action_interlocks lck
716: ,pay_payroll_actions ppa1