APPS.PAY_KR_PAYKRYTR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 483: pay_assignment_actions paa

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
487: and ppa.effective_date

Line 499: pay_assignment_actions paa,

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
503: and pi.assignment_id = paa.assignment_id

Line 520: pay_assignment_actions paa,

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
524: and pei.assignment_id = paa.assignment_id

Line 534: pay_assignment_actions paa,

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
538: and pi.assignment_id = paa.assignment_id

Line 548: pay_assignment_actions paa,

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
552: and pi.assignment_id = paa.assignment_id

Line 562: pay_assignment_actions paa,

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
566: and pi.assignment_id = paa.assignment_id

Line 579: pay_assignment_actions paa,

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
583: and pi.assignment_id = paa.assignment_id

Line 592: pay_assignment_actions paa

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: --
596: l_asg_details csr_asg_details%rowtype;