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

Line 191: from per_all_assignments_f ASG

187: p_people_group_id number
188: ) is
189: select ASG.effective_start_date,
190: ASG.effective_end_date
191: from per_all_assignments_f ASG
192: where ASG.assignment_id = p_assignment_id
193: and ASG.assignment_type = 'E'
194: and ASG.effective_start_date <= p_range_end_date
195: and ASG.effective_end_date >= p_range_start_date

Line 439: from per_all_assignments_f asg,

435: select asg.effective_start_date,
436: asg.effective_end_date,
437: asg.people_group_id,
438: ppg.id_flex_num
439: from per_all_assignments_f asg,
440: pay_people_groups ppg
441: where asg.assignment_id = p_assignment_id
442: and asg.people_group_id is not null
443: and asg.assignment_type not in ('A' ,'O') -- non-applicant assignments only

Line 721: from per_all_assignments_f asg

717: (pa.date_earned between l_validation_start_date
718: and p_validation_end_date))
719: and not (exists
720: (select null
721: from per_all_assignments_f asg
722: where asg.assignment_id = p_assignment_id
723: and pa.effective_date
724: between asg.effective_start_date
725: and asg.effective_end_date

Line 729: from per_all_assignments_f asg

725: and asg.effective_end_date
726: and asg.payroll_id + 0 = p_payroll_id)
727: and exists
728: (select null
729: from per_all_assignments_f asg
730: where asg.assignment_id = p_assignment_id
731: and nvl(pa.date_earned,pa.effective_date)
732: between asg.effective_start_date
733: and asg.effective_end_date

Line 741: from per_all_assignments_f asg

737: select 'Y'
738: from sys.dual
739: where not exists
740: (select null
741: from per_all_assignments_f asg
742: where asg.assignment_id = p_assignment_id
743: and p_date
744: between asg.effective_start_date
745: and asg.effective_end_date

Line 750: from per_all_assignments_f asg

746: and asg.payroll_id + 0 = p_payroll_id);
747:
748: cursor csr_asg is
749: select asg.effective_start_date
750: from per_all_assignments_f asg
751: where asg.assignment_id = p_assignment_id
752: and p_validation_start_date between
753: asg.effective_start_date and asg.effective_end_date;
754: --

Line 898: -- from per_all_assignments_f asg

894: -- (pa.date_earned between p_validation_start_date
895: -- and p_validation_end_date))
896: -- and not (exists
897: -- (select null
898: -- from per_all_assignments_f asg
899: -- where asg.assignment_id = p_assignment_id
900: -- and pa.effective_date
901: -- between asg.effective_start_date
902: -- and asg.effective_end_date

Line 906: -- from per_all_assignments_f asg

902: -- and asg.effective_end_date
903: -- and asg.payroll_id + 0 = p_payroll_id)
904: -- and exists
905: -- (select null
906: -- from per_all_assignments_f asg
907: -- where asg.assignment_id = p_assignment_id
908: -- and nvl(pa.date_earned,pa.effective_date)
909: -- between asg.effective_start_date
910: -- and asg.effective_end_date

Line 2104: from per_all_assignments_f asg

2100: asg.employment_category,
2101: asg.payroll_id,
2102: asg.pay_basis_id,
2103: asg.business_group_id
2104: from per_all_assignments_f asg
2105: where asg.assignment_id = p_assignment_id
2106: and p_validation_start_date between
2107: asg.effective_start_date and asg.effective_end_date;
2108: --

Line 2658: from per_all_assignments_f asg

2654: and et.processing_type='R'
2655: and (
2656: not exists
2657: (select null
2658: from per_all_assignments_f asg
2659: where asg.assignment_id = ee.assignment_id
2660: /* Added Benefits assignment type to the below code to ensure
2661: removal of entries wont happen in the case of benifits
2662: assignment type also */

Line 2793: FROM per_all_assignments_f

2789: is
2790: -- cursor added for 8870436
2791: CURSOR csr_bus_group(p_assignment_id number) IS
2792: SELECT business_group_id
2793: FROM per_all_assignments_f
2794: WHERE assignment_id = p_assignment_id;
2795:
2796: -- cursor added for 8870436
2797: CURSOR csr_leg_grp(p_business_group_id number) IS

Line 2960: FROM per_all_assignments_f

2956: is
2957: --
2958: CURSOR csr_bus_group(p_assignment_id number) IS
2959: SELECT business_group_id
2960: FROM per_all_assignments_f
2961: WHERE assignment_id = p_assignment_id;
2962:
2963: /*Cursor added for bug:7440183for getting leg code */
2964: CURSOR csr_leg_grp(p_business_group_id number) IS

Line 3115: FROM per_all_assignments_f

3111: is
3112: /* Added for bug #9370749 */
3113: CURSOR csr_bus_group(p_assignment_id number) IS
3114: SELECT business_group_id
3115: FROM per_all_assignments_f
3116: WHERE assignment_id = p_assignment_id;
3117:
3118: CURSOR csr_leg_grp(p_business_group_id number) IS
3119: SELECT LEGISLATION_CODE

Line 3560: from per_all_assignments_f asg,

3556: and el.element_type_id = et.element_type_id
3557: and et.processing_type = 'N')))
3558: and not exists
3559: (select null
3560: from per_all_assignments_f asg,
3561: pay_element_links_f el
3562: where el.element_link_id = ee.element_link_id
3563: and asg.assignment_id = ee.assignment_id
3564: and asg.assignment_type = 'E'

Line 3638: from per_all_assignments_f

3634: select 1
3635: into lv_asg_exists
3636: from dual
3637: where exists (select 1
3638: from per_all_assignments_f
3639: where assignment_id =p_assignment_id);
3640: Exception when no_data_found then
3641: lv_asg_exists:=0;
3642: end;

Line 4035: from per_all_assignments_f asg,

4031: -- criteria.
4032: --
4033: and not exists
4034: (select null
4035: from per_all_assignments_f asg,
4036: pay_element_links_f el
4037: where asg.assignment_id = ee.assignment_id
4038: and el.element_link_id = ee.element_link_id
4039: and asg.assignment_type = 'E'

Line 4132: per_all_assignments_f paf

4128: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/ plr.rule_mode
4129: into l_adjust_ee_source
4130: from pay_legislation_rules plr,
4131: per_business_groups_perf pbg,
4132: per_all_assignments_f paf
4133: where paf.assignment_id = p_assignment_id
4134: and p_validation_start_date between paf.effective_start_date
4135: and paf.effective_end_date
4136: and paf.business_group_id = pbg.business_group_id

Line 4393: from per_all_assignments_f

4389: and et.processing_type = 'N')));
4390: --
4391: cursor get_asg_start_date is -- bug 8359932
4392: select min(effective_start_date)
4393: from per_all_assignments_f
4394: where assignment_id = p_assignment_id;
4395:
4396: --
4397: -- Local Variables

Line 4453: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id

4449: hr_utility.trace ('1');
4450: end if;
4451: --
4452: select count(*) into v_start_date_check from per_time_periods where payroll_id in(
4453: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4454: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
4455: and p_val_start_date_minus_one between start_date and end_date;
4456:
4457: select count(*) into v_end_date_check from per_time_periods where payroll_id in(

Line 4458: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id

4454: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
4455: and p_val_start_date_minus_one between start_date and end_date;
4456:
4457: select count(*) into v_end_date_check from per_time_periods where payroll_id in(
4458: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4459: and p_val_end_date_plus_one between effective_start_date and effective_end_date)
4460: and p_val_end_date_plus_one between start_date and end_date;
4461:
4462: if g_debug then

Line 4479: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id

4475: end if;
4476: --
4477: if v_start_date_check<>0 or v_end_date_check<>0 then
4478: select end_date into v_vale_start_date from per_time_periods where payroll_id in(
4479: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4480: and v_chng_date between effective_start_date and effective_end_date)
4481: and v_chng_date between start_date and end_date;
4482: end if;
4483:

Line 6347: FROM per_all_assignments_f asg_cur, pay_element_entries_f peef

6343: -- Ensure when salary basis is removed in CORRECTION mode, salary
6344: -- element link is not picked up for eligibility criteria validation.
6345: and not exists (
6346: SELECT null
6347: FROM per_all_assignments_f asg_cur, pay_element_entries_f peef
6348: WHERE asg_cur.assignment_id = p_assignment_id
6349: AND asg_cur.effective_start_date = p_validation_start_date
6350: AND asg_cur.pay_basis_id is null
6351: AND EXISTS ( select null

Line 6352: from per_all_assignments_f asg_pre

6348: WHERE asg_cur.assignment_id = p_assignment_id
6349: AND asg_cur.effective_start_date = p_validation_start_date
6350: AND asg_cur.pay_basis_id is null
6351: AND EXISTS ( select null
6352: from per_all_assignments_f asg_pre
6353: where asg_pre.assignment_id = p_assignment_id
6354: and asg_pre.effective_end_date = p_val_start_date_minus_one
6355: and asg_pre.pay_basis_id is not null)
6356: AND peef.element_link_id = el.element_link_id

Line 6414: from per_all_assignments_f asg

6410: p_people_group_id number
6411: ) is
6412: select asg.effective_start_date,
6413: asg.effective_end_date
6414: from per_all_assignments_f asg
6415: where asg.assignment_id = p_assignment_id
6416: and asg.assignment_type = 'E'
6417: and asg.effective_start_date <= p_val_end_date_plus_one
6418: and asg.effective_end_date >= p_val_start_date_minus_one

Line 6982: from per_all_assignments_f asg

6978: open csr_assignment for
6979: select asg.assignment_id,
6980: asg.effective_start_date,
6981: asg.effective_end_date
6982: from per_all_assignments_f asg
6983: where asg.assignment_id = p_assignment_id
6984: and asg.assignment_type = 'E'
6985: and asg.effective_start_date <= p_effective_end_date
6986: and asg.effective_end_date >= p_effective_start_date

Line 7051: from per_all_assignments_f asg

7047: open csr_assignment for
7048: select asg.assignment_id,
7049: asg.effective_start_date,
7050: asg.effective_end_date
7051: from per_all_assignments_f asg
7052: where asg.business_group_id = p_business_group_id
7053: and asg.assignment_type = 'E'
7054: and asg.effective_start_date <= p_effective_end_date
7055: and asg.effective_end_date >= p_effective_start_date

Line 7122: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

7118: --
7119: -- Failed to lock the assignment.
7120: --
7121: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
7122: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
7123: hr_utility.raise_error;
7124: end;
7125: --
7126: -- Get first assignment piece matching the standard link.

Line 7300: FROM PER_ALL_ASSIGNMENTS_F asg

7296: asg.pay_basis_id
7297: --
7298: -- end criteria used for EL matching
7299: --
7300: FROM PER_ALL_ASSIGNMENTS_F asg
7301: WHERE asg.assignment_id = b_assignment_id
7302: and asg.business_group_id = b_business_group_id
7303: ORDER BY
7304: asg.assignment_id,

Line 8026: from per_all_assignments_f asg

8022: et.processing_type,
8023: ee.updating_action_id,
8024: ee.updating_action_type,
8025: ee.object_version_number
8026: from per_all_assignments_f asg
8027: , pay_element_entries_f ee
8028: , pay_element_types_f et
8029: where asg.assignment_id = c_assignment_id
8030: and asg.assignment_id = ee.assignment_id