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.PQP_NL_PGGM_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 139: FROM per_all_assignments_f

135: -- Cursor to fetch the org id for a given assignment id
136: --
137: CURSOR c_get_org_id IS
138: SELECT organization_id
139: FROM per_all_assignments_f
140: WHERE assignment_id = p_assignment_id
141: AND p_date_earned BETWEEN effective_start_date
142: AND effective_end_date;
143:

Line 449: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

445: --=============================================================================
446: -- Function to get the age of a person given the effective date
447: --=============================================================================
448: FUNCTION Get_Age
449: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
450: ,p_effective_date IN DATE
451: ,p_begin_of_year_date IN DATE)
452: RETURN NUMBER IS
453:

Line 457: ,per_all_assignments_f paf

453:
454: CURSOR get_dob IS
455: SELECT trunc(date_of_birth)
456: FROM per_all_people_f per
457: ,per_all_assignments_f paf
458: WHERE per.person_id = paf.person_id
459: AND paf.assignment_id = p_assignment_id
460: AND p_effective_date BETWEEN per.effective_start_date
461: AND per.effective_end_date

Line 730: FROM per_all_assignments_f asg,per_assignment_status_types past

726: --
727: CURSOR c_get_asg_dates IS
728: SELECT asg.effective_start_date start_date
729: ,nvl(asg.effective_end_date,p_period_end_date) end_date
730: FROM per_all_assignments_f asg,per_assignment_status_types past
731: WHERE asg.assignment_id = p_assignment_id
732: AND asg.assignment_status_type_id = past.assignment_status_type_id
733: AND past.per_system_status = 'ACTIVE_ASSIGN'
734: AND asg.effective_start_date <= p_period_end_date

Line 883: FROM per_all_assignments_f

879: -- Cursor to fetch the org id for the current assignment
880: --
881: CURSOR c_get_org_id IS
882: SELECT organization_id
883: FROM per_all_assignments_f
884: WHERE assignment_id = p_assignment_id
885: AND p_date_earned BETWEEN effective_start_date
886: AND effective_end_date;
887:

Line 1047: FROM per_all_assignments_f asg

1043: -- Cursor to get the hire date of the person
1044: --
1045: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
1046: SELECT max(date_start)
1047: FROM per_all_assignments_f asg
1048: ,per_periods_of_service pps
1049: WHERE pps.person_id = asg.person_id
1050: AND asg.assignment_id = c_asg_id
1051: AND pps.business_group_id = p_business_group_id

Line 1073: FROM per_all_assignments_f

1069: --Cursor to fetch the assignment start date
1070: --
1071: CURSOR c_get_asg_start IS
1072: SELECT min(effective_start_date)
1073: FROM per_all_assignments_f
1074: WHERE assignment_id = p_assignment_id;
1075:
1076: --
1077: -- Cursor to get the defined balance id for a given balance and dimension

Line 1112: ,per_all_assignments_f asg

1108: CURSOR c_cag_name (c_asg_id IN NUMBER
1109: ,c_eff_date IN DATE) IS
1110: SELECT cola.name
1111: FROM per_collective_agreements cola
1112: ,per_all_assignments_f asg
1113: WHERE asg.assignment_id = c_asg_id
1114: AND asg.collective_agreement_id = cola.collective_agreement_id
1115: AND cola.status = 'A'
1116: AND c_eff_date BETWEEN asg.effective_start_date

Line 1137: FROM per_all_assignments_f

1133: --attached to this assignment
1134: --
1135: CURSOR c_get_org_id(c_eff_date IN DATE) IS
1136: SELECT organization_id
1137: FROM per_all_assignments_f
1138: WHERE assignment_id = p_assignment_id
1139: AND c_eff_date BETWEEN effective_start_date
1140: AND effective_end_date;
1141:

Line 1717: FROM per_all_assignments_f

1713: -- for this period
1714: --
1715: CURSOR c_get_st_date IS
1716: SELECT min(effective_start_date)
1717: FROM per_all_assignments_f
1718: WHERE assignment_id = p_assignment_id
1719: AND effective_end_date >= p_period_start_date;
1720: --
1721: --Cursor to fetch the part time percentage from the

Line 2025: FROM per_all_assignments_f asg

2021: )
2022: RETURN NUMBER IS
2023: CURSOR csr_get_inci_wkr_code(c_assignment_id NUMBER,c_date_earned DATE) IS
2024: SELECT scl.SEGMENT1
2025: FROM per_all_assignments_f asg
2026: ,hr_soft_coding_keyflex scl
2027: WHERE asg.assignment_id = c_assignment_id
2028: AND c_date_earned BETWEEN asg.effective_start_date
2029: AND asg.effective_end_date