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 151: FROM per_all_assignments_f

147: -- Cursor to fetch the org id for a given assignment id
148: --
149: CURSOR c_get_org_id IS
150: SELECT organization_id
151: FROM per_all_assignments_f
152: WHERE assignment_id = p_assignment_id
153: AND p_date_earned BETWEEN effective_start_date
154: AND effective_end_date;
155:

Line 564: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE

560: --=============================================================================
561: -- Function to get the age of a person given the effective date
562: --=============================================================================
563: FUNCTION Get_Age
564: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
565: ,p_effective_date IN DATE
566: ,p_begin_of_year_date IN DATE)
567: RETURN NUMBER IS
568:

Line 572: ,per_all_assignments_f paf

568:
569: CURSOR get_dob IS
570: SELECT trunc(date_of_birth)
571: FROM per_all_people_f per
572: ,per_all_assignments_f paf
573: WHERE per.person_id = paf.person_id
574: AND paf.assignment_id = p_assignment_id
575: AND p_effective_date BETWEEN per.effective_start_date
576: AND per.effective_end_date

Line 884: FROM per_all_assignments_f asg,per_assignment_status_types past

880: --
881: CURSOR c_get_asg_dates IS
882: SELECT asg.effective_start_date start_date
883: ,nvl(asg.effective_end_date,p_period_end_date) end_date
884: FROM per_all_assignments_f asg,per_assignment_status_types past
885: WHERE asg.assignment_id = p_assignment_id
886: AND asg.assignment_status_type_id = past.assignment_status_type_id
887: AND past.per_system_status = 'ACTIVE_ASSIGN'
888: AND asg.effective_start_date <= p_period_end_date

Line 1037: FROM per_all_assignments_f

1033: -- Cursor to fetch the org id for the current assignment
1034: --
1035: CURSOR c_get_org_id IS
1036: SELECT organization_id
1037: FROM per_all_assignments_f
1038: WHERE assignment_id = p_assignment_id
1039: AND p_date_earned BETWEEN effective_start_date
1040: AND effective_end_date;
1041:

Line 1201: FROM per_all_assignments_f asg

1197: -- Cursor to get the hire date of the person
1198: --
1199: CURSOR c_hire_dt_cur(c_asg_id IN NUMBER) IS
1200: SELECT max(date_start)
1201: FROM per_all_assignments_f asg
1202: ,per_periods_of_service pps
1203: WHERE pps.person_id = asg.person_id
1204: AND asg.assignment_id = c_asg_id
1205: AND pps.business_group_id = p_business_group_id

Line 1227: FROM per_all_assignments_f

1223: --Cursor to fetch the assignment start date
1224: --
1225: CURSOR c_get_asg_start IS
1226: SELECT min(effective_start_date)
1227: FROM per_all_assignments_f
1228: WHERE assignment_id = p_assignment_id;
1229:
1230: --
1231: -- Cursor to get the defined balance id for a given balance and dimension

Line 1266: ,per_all_assignments_f asg

1262: CURSOR c_cag_name (c_asg_id IN NUMBER
1263: ,c_eff_date IN DATE) IS
1264: SELECT cola.name
1265: FROM per_collective_agreements cola
1266: ,per_all_assignments_f asg
1267: WHERE asg.assignment_id = c_asg_id
1268: AND asg.collective_agreement_id = cola.collective_agreement_id
1269: AND cola.status = 'A'
1270: AND c_eff_date BETWEEN asg.effective_start_date

Line 1291: FROM per_all_assignments_f

1287: --attached to this assignment
1288: --
1289: CURSOR c_get_org_id(c_eff_date IN DATE) IS
1290: SELECT organization_id
1291: FROM per_all_assignments_f
1292: WHERE assignment_id = p_assignment_id
1293: AND c_eff_date BETWEEN effective_start_date
1294: AND effective_end_date;
1295:

Line 1871: FROM per_all_assignments_f

1867: -- for this period
1868: --
1869: CURSOR c_get_st_date IS
1870: SELECT min(effective_start_date)
1871: FROM per_all_assignments_f
1872: WHERE assignment_id = p_assignment_id
1873: AND effective_end_date >= p_period_start_date;
1874: --
1875: --Cursor to fetch the part time percentage from the

Line 2179: FROM per_all_assignments_f asg

2175: )
2176: RETURN NUMBER IS
2177: CURSOR csr_get_inci_wkr_code(c_assignment_id NUMBER,c_date_earned DATE) IS
2178: SELECT scl.SEGMENT1
2179: FROM per_all_assignments_f asg
2180: ,hr_soft_coding_keyflex scl
2181: WHERE asg.assignment_id = c_assignment_id
2182: AND c_date_earned BETWEEN asg.effective_start_date
2183: AND asg.effective_end_date