eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_EOY_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 649: FROM per_all_assignments_f paf

645: CURSOR csr_asg_contribution is
646: SELECT paf.assignment_id
647: ,greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
648: ,least( p_effective_date, paf.effective_end_date) end_date
649: FROM per_all_assignments_f paf
650: ,hr_soft_coding_keyflex sck
651: ,hr_organization_information hoi
652: ,per_assignment_status_types pas
653: WHERE paf.person_id = p_person_id

Line 666: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

662: OR (trunc(p_effective_date,'Y') > paf.effective_start_date
663: AND p_effective_date < paf.effective_end_date))
664: ORDER BY paf.effective_start_date;
665: --
666: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
667: l_first_flag NUMBER;
668: --
669: rec_asg_contribution csr_asg_contribution%ROWTYPE;
670: --

Line 749: FROM per_all_assignments_f paf

745: --
746: CURSOR csr_asg_contribution is
747: SELECT greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
748: ,least( p_effective_date, paf.effective_end_date) end_date
749: FROM per_all_assignments_f paf
750: ,hr_soft_coding_keyflex sck
751: ,hr_organization_information hoi
752: ,per_assignment_status_types pas
753: WHERE paf.person_id = p_person_id

Line 766: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;

762: OR (trunc(p_effective_date,'Y') > paf.effective_start_date
763: AND p_effective_date < paf.effective_end_date))
764: ORDER BY paf.effective_start_date;
765: --
766: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
767: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
768: l_first_flag NUMBER;
769: l_days NUMBER;
770: --

Line 767: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

763: AND p_effective_date < paf.effective_end_date))
764: ORDER BY paf.effective_start_date;
765: --
766: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
767: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
768: l_first_flag NUMBER;
769: l_days NUMBER;
770: --
771: rec_asg_contribution csr_asg_contribution%ROWTYPE;

Line 1813: FROM per_all_assignments_f asg

1809: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE') ni_zone
1810: ,MAX(ppa.effective_date) effective_date
1811: ,MAX(asg.effective_end_date) effective_end_date
1812: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1813: FROM per_all_assignments_f asg
1814: ,pay_assignment_actions paa
1815: ,pay_payroll_actions ppa
1816: ,pay_action_information ai
1817: ,pay_action_contexts ac1