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

Line 244: from per_all_assignments_f ASSIGNMENT,

240: --
241: --
242: l_execution_stmt :=
243: 'select 1
244: from per_all_assignments_f ASSIGNMENT,
245: per_all_people_f PERSON,
246: per_person_type_usages_f PERSON_TYPE
247: where ASSIGNMENT.assignment_id = :asg_id
248: and to_date(:asg_eff_date,''dd-mon-yyyy'')

Line 331: from per_all_assignments_f paf,

327: paf.business_group_id,
328: paf.assignment_type,
329: ppf.current_employee_flag,
330: ppf.current_npw_flag
331: from per_all_assignments_f paf,
332: per_all_people_f ppf
333: where paf.assignment_id = p_assignment_id
334: and p_effective_date between paf.effective_start_date
335: and paf.effective_end_date

Line 340: l_person_id per_all_assignments_f.person_id%type;

336: and paf.person_id = ppf.person_id
337: and p_effective_date between ppf.effective_start_date
338: and ppf.effective_end_date;
339: --
340: l_person_id per_all_assignments_f.person_id%type;
341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;

Line 341: l_organization_id per_all_assignments_f.organization_id%type;

337: and p_effective_date between ppf.effective_start_date
338: and ppf.effective_end_date;
339: --
340: l_person_id per_all_assignments_f.person_id%type;
341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;

Line 342: l_position_id per_all_assignments_f.position_id%type;

338: and ppf.effective_end_date;
339: --
340: l_person_id per_all_assignments_f.person_id%type;
341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;

Line 343: l_payroll_id per_all_assignments_f.payroll_id%type;

339: --
340: l_person_id per_all_assignments_f.person_id%type;
341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;
347: l_current_npw_flag per_all_people_f.current_npw_flag%type;

Line 344: l_business_group_id per_all_assignments_f.business_group_id%type;

340: l_person_id per_all_assignments_f.person_id%type;
341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;
347: l_current_npw_flag per_all_people_f.current_npw_flag%type;
348: --

Line 345: l_assignment_type per_all_assignments_f.assignment_type%type;

341: l_organization_id per_all_assignments_f.organization_id%type;
342: l_position_id per_all_assignments_f.position_id%type;
343: l_payroll_id per_all_assignments_f.payroll_id%type;
344: l_business_group_id per_all_assignments_f.business_group_id%type;
345: l_assignment_type per_all_assignments_f.assignment_type%type;
346: l_current_employee_flag per_all_people_f.current_employee_flag%type;
347: l_current_npw_flag per_all_people_f.current_npw_flag%type;
348: --
349: l_program_id number(15) := fnd_profile.value('CONC_PROGRAM_ID');

Line 2820: from per_all_assignments_f asg

2816: , asg.organization_id
2817: , asg.position_id
2818: , asg.payroll_id
2819: , asg.business_group_id
2820: from per_all_assignments_f asg
2821: where asg.person_id=p_person_id
2822: and ( (asg.assignment_type='E'
2823: and asg.effective_end_date = (select max(p.actual_termination_date)
2824: from per_periods_of_service p

Line 3332: FROM per_all_assignments_f paaf

3328: -- user permissions.
3329: --
3330: CURSOR csr_assignments_for_per IS
3331: SELECT *
3332: FROM per_all_assignments_f paaf
3333: WHERE paaf.person_id = p_person_id
3334: AND p_effective_date BETWEEN
3335: paaf.effective_start_date AND paaf.effective_end_date
3336: AND paaf.assignment_type NOT IN ('A','B');

Line 4018: from per_all_assignments_f paaf

4014: and p_effective_date between pcr.date_start
4015: and nvl(pcr.date_end, hr_api.g_eot)
4016: and not exists
4017: (select null
4018: from per_all_assignments_f paaf
4019: where paaf.person_id = pcr.contact_person_id
4020: and paaf.ASSIGNMENT_TYPE <> 'B'); -- Bug 4450149
4021: -- Gets all unrelated contacts (excluding the candidates - registered
4022: -- users from iRec) for the business group, or globally if using a global

Line 4024: -- Here the numbers are checked instead of hitting per_all_assignments_f.

4020: and paaf.ASSIGNMENT_TYPE <> 'B'); -- Bug 4450149
4021: -- Gets all unrelated contacts (excluding the candidates - registered
4022: -- users from iRec) for the business group, or globally if using a global
4023: -- profile. The people cannot have any current or historical assignments.
4024: -- Here the numbers are checked instead of hitting per_all_assignments_f.
4025: cursor csr_unrelated_contacts is
4026: select distinct papf.person_id
4027: from per_all_people_f papf
4028: where (p_business_group_id is null or

Line 4159: from per_all_assignments_f paaf

4155: and ptuf.person_type_id = ppt.person_type_id
4156: and ppt.business_group_id + 0 = nvl(p_business_group_id,ppt.business_group_id)--fix for bug 5222441.
4157: and not exists
4158: (select null
4159: from per_all_assignments_f paaf
4160: where paaf.person_id = ptuf.person_id)
4161: and not exists
4162: (select null
4163: from per_contact_relationships pcr

Line 4627: FROM per_all_assignments_f hr_asg ';

4623: --
4624: l_select_from_clause :=
4625: 'SELECT hr_asg.assignment_id
4626: ,hr_asg.person_id
4627: FROM per_all_assignments_f hr_asg ';
4628:
4629: /*-- Check for the Supervisor Security --*/
4630: /* -- In the New enhancement we are ignoring the supervisor security from
4631: showing the Ex-Employee and Future Employee records (New enhancement)

Line 4664: ( select null from per_all_assignments_f papf

4660: (:effective_date BETWEEN hr_asg.effective_start_date AND hr_asg.effective_end_date
4661: /* Ex-Employee */
4662: or (hr_asg.effective_end_date < :effective_date
4663: and not exists
4664: ( select null from per_all_assignments_f papf
4665: where papf.person_id = hr_asg.person_id
4666: and papf.assignment_type in (''A'',''C'',''E'')
4667: and papf.effective_end_date >= :effective_date )
4668: )

Line 4673: ( select null from per_all_assignments_f papf

4669: /* End Ex-Employee */
4670: /* Future Employee */
4671: or ( hr_asg.effective_start_date > :effective_date
4672: and not exists
4673: ( select null from per_all_assignments_f papf
4674: where papf.person_id = hr_asg.person_id
4675: and papf.assignment_type in (''A'',''C'',''E'')
4676: and papf.effective_start_date < hr_asg.effective_start_date )
4677: )

Line 4828: FROM per_all_assignments_f ASSIGNMENT,

4824: ELSE
4825: /* -- The l_temp_clause is changed for the enhancement */
4826: l_temp_clause := and_clause(l_temp_clause, and_clause(
4827: 'EXISTS (SELECT NULL
4828: FROM per_all_assignments_f ASSIGNMENT,
4829: per_all_people_f PERSON,
4830: per_person_type_usages_f PERSON_TYPE
4831: WHERE ASSIGNMENT.rowid = hr_asg.rowid
4832: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id

Line 5149: FROM per_all_assignments_f ASSIGNMENT,

5145: ,'ASSIGNMENT.', 'hr_asg.'));
5146: ELSE
5147: l_temp_clause := and_clause(l_temp_clause, and_clause(
5148: 'EXISTS (SELECT NULL
5149: FROM per_all_assignments_f ASSIGNMENT,
5150: per_all_people_f PERSON,
5151: per_person_type_usages_f PERSON_TYPE
5152: WHERE ASSIGNMENT.rowid = hr_asg.rowid
5153: AND ASSIGNMENT.ASSIGNMENT_ID = hr_asg.assignment_id /* For the bug 6196437 */

Line 6014: FROM per_all_assignments_f paaf

6010: WHERE plc.security_profile_id IS NOT NULL
6011: AND plc.security_profile_id = p_security_profile_id
6012: AND NOT EXISTS
6013: (SELECT NULL
6014: FROM per_all_assignments_f paaf
6015: WHERE paaf.person_id = plc.person_id
6016: AND paaf.assignment_type <> 'B'
6017: AND p_effective_date BETWEEN
6018: paaf.effective_start_date AND paaf.effective_end_date)

Line 6021: FROM per_all_assignments_f paaf2

6017: AND p_effective_date BETWEEN
6018: paaf.effective_start_date AND paaf.effective_end_date)
6019: AND EXISTS
6020: (SELECT NULL
6021: FROM per_all_assignments_f paaf2
6022: WHERE paaf2.person_id = plc.person_id
6023: AND paaf2.assignment_type <> 'B'
6024: AND p_effective_date > paaf2.effective_start_date);
6025:

Line 6101: FROM per_all_assignments_f paaf

6097: --
6098: CURSOR csr_get_asgs_for_per
6099: (p_person_id IN NUMBER) IS
6100: SELECT paaf.assignment_id
6101: FROM per_all_assignments_f paaf
6102: WHERE paaf.person_id = p_person_id
6103: AND p_effective_date BETWEEN
6104: paaf.effective_start_date AND paaf.effective_end_date
6105: AND paaf.assignment_type <> 'B';