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 2860: from per_all_assignments_f asg

2856: , asg.organization_id
2857: , asg.position_id
2858: , asg.payroll_id
2859: , asg.business_group_id
2860: from per_all_assignments_f asg
2861: where asg.person_id=p_person_id
2862: and ( (asg.assignment_type='E'
2863: and asg.effective_end_date = (select max(p.actual_termination_date)
2864: from per_periods_of_service p

Line 3372: FROM per_all_assignments_f paaf

3368: -- user permissions.
3369: --
3370: CURSOR csr_assignments_for_per IS
3371: SELECT *
3372: FROM per_all_assignments_f paaf
3373: WHERE paaf.person_id = p_person_id
3374: AND p_effective_date BETWEEN
3375: paaf.effective_start_date AND paaf.effective_end_date
3376: AND paaf.assignment_type NOT IN ('A','B');

Line 4058: from per_all_assignments_f paaf

4054: and p_effective_date between pcr.date_start
4055: and nvl(pcr.date_end, hr_api.g_eot)
4056: and not exists
4057: (select null
4058: from per_all_assignments_f paaf
4059: where paaf.person_id = pcr.contact_person_id
4060: and paaf.ASSIGNMENT_TYPE <> 'B'); -- Bug 4450149
4061: -- Gets all unrelated contacts (excluding the candidates - registered
4062: -- users from iRec) for the business group, or globally if using a global

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

4060: and paaf.ASSIGNMENT_TYPE <> 'B'); -- Bug 4450149
4061: -- Gets all unrelated contacts (excluding the candidates - registered
4062: -- users from iRec) for the business group, or globally if using a global
4063: -- profile. The people cannot have any current or historical assignments.
4064: -- Here the numbers are checked instead of hitting per_all_assignments_f.
4065: cursor csr_unrelated_contacts is
4066: select distinct papf.person_id
4067: from per_all_people_f papf
4068: where (p_business_group_id is null or

Line 4199: from per_all_assignments_f paaf

4195: and ptuf.person_type_id = ppt.person_type_id
4196: and ppt.business_group_id + 0 = nvl(p_business_group_id,ppt.business_group_id)--fix for bug 5222441.
4197: and not exists
4198: (select null
4199: from per_all_assignments_f paaf
4200: where paaf.person_id = ptuf.person_id)
4201: and not exists
4202: (select null
4203: from per_contact_relationships pcr

Line 4256: per_all_assignments_f paaf,

4252: --
4253: cursor csr_rtm_candidates(p_person_id number) is
4254: select paaf.person_id,paaf.assignment_id
4255: from per_all_people_f papf,
4256: per_all_assignments_f paaf,
4257: irc_rec_team_members irt
4258: where papf.person_id = paaf.person_id
4259: and nvl(paaf.vacancy_id,(select distinct vacancy_id from PER_VAC_LINKED_ASSIGNMENTS
4260: where tgt_apl_asg_id=paaf.assignment_id and rownum<2)) = irt.vacancy_id

Line 4670: l_paaf_name varchar2(30) := 'per_all_assignments_f';

4666: '(hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')';
4667: -- '(hr_asg.payroll_id IS NULL OR hr_security_internal.show_payroll(hr_asg.payroll_id) = ''TRUE'')'; -- Modified the statement for bug 11737636.
4668:
4669: --- Bug # 12739699 ---
4670: l_paaf_name varchar2(30) := 'per_all_assignments_f';
4671: --- Bug # 12739699 ---
4672: BEGIN
4673:
4674: IF g_dbg THEN op('Entering: '||l_proc, 1); END IF;

Line 4752: l_paaf_name := 'per_all_assignments_f_perf';

4748: --
4749:
4750: --- Bug # 12739699 ---
4751: if NVL(fnd_profile.value('PER_SECURITY_ENHANCER'),'N') = 'PERF_ASG' then
4752: l_paaf_name := 'per_all_assignments_f_perf';
4753: else
4754: l_paaf_name := 'per_all_assignments_f';
4755: end if;
4756: --- Bug # 12739699 ---

Line 4754: l_paaf_name := 'per_all_assignments_f';

4750: --- Bug # 12739699 ---
4751: if NVL(fnd_profile.value('PER_SECURITY_ENHANCER'),'N') = 'PERF_ASG' then
4752: l_paaf_name := 'per_all_assignments_f_perf';
4753: else
4754: l_paaf_name := 'per_all_assignments_f';
4755: end if;
4756: --- Bug # 12739699 ---
4757:
4758: l_select_from_clause :=

Line 6258: FROM per_all_assignments_f paaf

6254: WHERE plc.security_profile_id IS NOT NULL
6255: AND plc.security_profile_id = p_security_profile_id
6256: AND NOT EXISTS
6257: (SELECT NULL
6258: FROM per_all_assignments_f paaf
6259: WHERE paaf.person_id = plc.person_id
6260: AND paaf.assignment_type <> 'B'
6261: AND p_effective_date BETWEEN
6262: paaf.effective_start_date AND paaf.effective_end_date)

Line 6265: FROM per_all_assignments_f paaf2

6261: AND p_effective_date BETWEEN
6262: paaf.effective_start_date AND paaf.effective_end_date)
6263: AND EXISTS
6264: (SELECT NULL
6265: FROM per_all_assignments_f paaf2
6266: WHERE paaf2.person_id = plc.person_id
6267: AND paaf2.assignment_type <> 'B'
6268: AND p_effective_date > paaf2.effective_start_date);
6269:

Line 6345: FROM per_all_assignments_f paaf

6341: --
6342: CURSOR csr_get_asgs_for_per
6343: (p_person_id IN NUMBER) IS
6344: SELECT paaf.assignment_id
6345: FROM per_all_assignments_f paaf
6346: WHERE paaf.person_id = p_person_id
6347: AND p_effective_date BETWEEN
6348: paaf.effective_start_date AND paaf.effective_end_date
6349: AND paaf.assignment_type <> 'B';

Line 9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;

9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,

Line 9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);

9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,

Line 9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');

9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)

Line 9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF

9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,

Line 9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;

9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,
9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);

Line 9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);

9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception

Line 9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');

9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then