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 556: FROM per_all_assignments_f paf

552: CURSOR csr_asg_contribution is
553: SELECT paf.assignment_id
554: ,greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
555: ,least( p_effective_date, paf.effective_end_date) end_date
556: FROM per_all_assignments_f paf
557: ,hr_soft_coding_keyflex sck
558: ,hr_organization_information hoi
559: ,per_assignment_status_types pas
560: WHERE paf.person_id = p_person_id

Line 573: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

569: OR (trunc(p_effective_date,'Y') > paf.effective_start_date
570: AND p_effective_date < paf.effective_end_date))
571: ORDER BY paf.effective_start_date;
572: --
573: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
574: l_first_flag NUMBER;
575: --
576: rec_asg_contribution csr_asg_contribution%ROWTYPE;
577: --

Line 656: FROM per_all_assignments_f paf

652: --
653: CURSOR csr_asg_contribution is
654: SELECT greatest( trunc(p_effective_date,'Y'), paf.effective_start_date) start_date
655: ,least( p_effective_date, paf.effective_end_date) end_date
656: FROM per_all_assignments_f paf
657: ,hr_soft_coding_keyflex sck
658: ,hr_organization_information hoi
659: ,per_assignment_status_types pas
660: WHERE paf.person_id = p_person_id

Line 673: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;

669: OR (trunc(p_effective_date,'Y') > paf.effective_start_date
670: AND p_effective_date < paf.effective_end_date))
671: ORDER BY paf.effective_start_date;
672: --
673: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
674: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
675: l_first_flag NUMBER;
676: l_days NUMBER;
677: --

Line 674: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;

670: AND p_effective_date < paf.effective_end_date))
671: ORDER BY paf.effective_start_date;
672: --
673: l_asg_start_date per_all_assignments_f.effective_start_date%TYPE;
674: l_asg_end_date per_all_assignments_f.effective_end_date%TYPE;
675: l_first_flag NUMBER;
676: l_days NUMBER;
677: --
678: rec_asg_contribution csr_asg_contribution%ROWTYPE;

Line 1632: FROM per_all_assignments_f asg

1628: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE') ni_zone
1629: ,MAX(ppa.effective_date) effective_date
1630: ,MAX(asg.effective_end_date) effective_end_date
1631: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1632: FROM per_all_assignments_f asg
1633: ,pay_assignment_actions paa
1634: ,pay_payroll_actions ppa
1635: ,pay_action_information ai
1636: ,pay_action_contexts ac1