APPS.PAY_KR_PAYKRYTR_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 498: from per_assignment_extra_info pi,

494:
495: -- 4289780
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

Line 519: from per_assignment_extra_info pei,

515: aei_information6 emp_ins_exp_nts, -- Bug 5667762
516: aei_information8 emp_tm_card_exp_nts, -- Bug 14502155
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

Line 533: from per_assignment_extra_info pi,

529: cursor csr_get_emp_exp_amount is
530: select nvl(to_number(aei_information18), 0) + nvl(to_number(aei_information19), 0) +
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

Line 547: from per_assignment_extra_info pi,

543: cursor csr_get_emp_card_expense is
544: select nvl(to_number(aei_information7), 0),
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

Line 561: from per_assignment_extra_info pi,

557: cursor csr_get_tm_emp_card_expense is
558: select nvl(to_number(aei_information3), 0),
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

Line 578: from per_assignment_extra_info pi,

574: nvl(to_number(aei_information6), 0) +
575: nvl(to_number(aei_information7), 0),
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