[Home] [Help]
478: ppa.effective_date
479: from per_people_f per,
480: per_periods_of_service pds,
481: per_assignments_f asg,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa
484: where paa.assignment_action_id = p_assignment_action_id
485: and ppa.payroll_action_id = paa.payroll_action_id
486: and asg.assignment_id = paa.assignment_id
496: cursor csr_cash_receipt is
497: select to_number(pi.aei_information13) "Cash Receipt"
498: from per_assignment_extra_info pi,
499: pay_assignment_actions paa,
500: pay_payroll_actions ppa
501: where paa.assignment_action_id = p_assignment_action_id
502: and ppa.payroll_action_id = paa.payroll_action_id
503: and pi.assignment_id = paa.assignment_id
504: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
517: aei_information9 emp_tm_direct_exp_nts, -- Bug 14502155
518: aei_information10 emp_tuition_paid_exp_nts -- Bug 14502155
519: from per_assignment_extra_info pei,
520: pay_assignment_actions paa,
521: pay_payroll_actions ppa
522: where paa.assignment_action_id = p_assignment_action_id
523: and ppa.payroll_action_id = paa.payroll_action_id
524: and pei.assignment_id = paa.assignment_id
525: and pei.information_type = 'KR_YEA_EMP_EXPENSE_DETAILS'
531: nvl(to_number(aei_information20), 0) + nvl(to_number(aei_information22), 0) +
532: nvl(to_number(aei_information23), 0) + nvl(to_number(aei_information30), 0)
533: from per_assignment_extra_info pi,
534: pay_assignment_actions paa,
535: pay_payroll_actions ppa
536: where paa.assignment_action_id = p_assignment_action_id
537: and ppa.payroll_action_id = paa.payroll_action_id
538: and pi.assignment_id = paa.assignment_id
539: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
545: nvl(to_number(aei_information10), 0),
546: nvl(to_number(aei_information12), 0)
547: from per_assignment_extra_info pi,
548: pay_assignment_actions paa,
549: pay_payroll_actions ppa
550: where paa.assignment_action_id = p_assignment_action_id
551: and ppa.payroll_action_id = paa.payroll_action_id
552: and pi.assignment_id = paa.assignment_id
553: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO'
559: nvl(to_number(aei_information5), 0),
560: nvl(to_number(aei_information7), 0)
561: from per_assignment_extra_info pi,
562: pay_assignment_actions paa,
563: pay_payroll_actions ppa
564: where paa.assignment_action_id = p_assignment_action_id
565: and ppa.payroll_action_id = paa.payroll_action_id
566: and pi.assignment_id = paa.assignment_id
567: and pi.information_type = 'KR_YEA_TAX_EXEM_INFO2'
576: nvl(to_number(aei_information8), 0),
577: nvl(to_number(aei_information2),0)
578: from per_assignment_extra_info pi,
579: pay_assignment_actions paa,
580: pay_payroll_actions ppa
581: where paa.assignment_action_id = p_assignment_action_id
582: and ppa.payroll_action_id = paa.payroll_action_id
583: and pi.assignment_id = paa.assignment_id
584: and pi.information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
587:
588: -- Bug 5726158
589: cursor csr_asg_details is
590: select paa.assignment_id, ppa.effective_date
591: from pay_payroll_actions ppa,
592: pay_assignment_actions paa
593: where paa.assignment_action_id = p_assignment_action_id
594: and ppa.payroll_action_id = paa.payroll_action_id;
595: --