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.PQH_PSF_BUS dependencies on FND_DATE

Line 1450: select fnd_date.canonical_to_date(poei_information3), fnd_date.canonical_to_date(poei_information4)

1446: from hr_all_positions
1447: where position_id = p_position_id;
1448:
1449: cursor c2 is
1450: select fnd_date.canonical_to_date(poei_information3), fnd_date.canonical_to_date(poei_information4)
1451: from per_position_extra_info
1452: where information_type = 'PER_OVERLAP'
1453: and position_id = p_position_id;
1454:

Line 1488: select fnd_date.canonical_to_date(poei_information3) poei_information3,

1484: l_fte_reserved number(15,2);
1485: l_person_id number(15);
1486:
1487: cursor c1 is
1488: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1489: nvl(fnd_date.canonical_to_date(poei_information4),
1490: hr_general.end_of_time) poei_information4,
1491: poei_information5, poei_information6, poei_information7
1492: from per_position_extra_info

Line 1489: nvl(fnd_date.canonical_to_date(poei_information4),

1485: l_person_id number(15);
1486:
1487: cursor c1 is
1488: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1489: nvl(fnd_date.canonical_to_date(poei_information4),
1490: hr_general.end_of_time) poei_information4,
1491: poei_information5, poei_information6, poei_information7
1492: from per_position_extra_info
1493: where position_id = p_position_id

Line 1692: between fnd_date.canonical_to_date(poei_information3)

1688: cursor c2 is
1689: select 'x'
1690: from per_position_extra_info
1691: where p_assignment_start_date
1692: between fnd_date.canonical_to_date(poei_information3)
1693: and fnd_date.canonical_to_date(poei_information4)
1694: and position_id = p_position_id
1695: and information_type = 'PER_OVERLAP';
1696: begin

Line 1693: and fnd_date.canonical_to_date(poei_information4)

1689: select 'x'
1690: from per_position_extra_info
1691: where p_assignment_start_date
1692: between fnd_date.canonical_to_date(poei_information3)
1693: and fnd_date.canonical_to_date(poei_information4)
1694: and position_id = p_position_id
1695: and information_type = 'PER_OVERLAP';
1696: begin
1697: if p_overlap_period is not null

Line 2661: between fnd_date.canonical_to_date(poei_information3)

2657: cursor c1(p_person_id number, p_position_id number, p_effective_date date) is
2658: select to_number(poei_information6,'99999999.99') fte
2659: from per_position_extra_info
2660: where p_effective_date
2661: between fnd_date.canonical_to_date(poei_information3)
2662: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2663: and position_id = p_position_id
2664: and information_type= 'PER_RESERVED'
2665: and poei_information5 = p_person_id;

Line 2662: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2658: select to_number(poei_information6,'99999999.99') fte
2659: from per_position_extra_info
2660: where p_effective_date
2661: between fnd_date.canonical_to_date(poei_information3)
2662: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2663: and position_id = p_position_id
2664: and information_type= 'PER_RESERVED'
2665: and poei_information5 = p_person_id;
2666: begin

Line 2696: between fnd_date.canonical_to_date(poei_information3)

2692: cursor c1(p_position_id number, p_effective_date date) is
2693: select sum(to_number(poei_information6,'99999999.99')) fte
2694: from per_position_extra_info
2695: where p_effective_date
2696: between fnd_date.canonical_to_date(poei_information3)
2697: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2698: and position_id = p_position_id
2699: and information_type= 'PER_RESERVED';
2700: --

Line 2697: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2693: select sum(to_number(poei_information6,'99999999.99')) fte
2694: from per_position_extra_info
2695: where p_effective_date
2696: between fnd_date.canonical_to_date(poei_information3)
2697: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2698: and position_id = p_position_id
2699: and information_type= 'PER_RESERVED';
2700: --
2701: begin

Line 2742: between fnd_date.canonical_to_date(poei_information3)

2738: cursor c1(p_position_id number, p_effective_date date) is
2739: select poei_information5 person_id
2740: from per_position_extra_info
2741: where p_effective_date
2742: between fnd_date.canonical_to_date(poei_information3)
2743: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2744: and position_id = p_position_id
2745: and poei_information5 is not null
2746: and information_type= 'PER_RESERVED';

Line 2743: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

2739: select poei_information5 person_id
2740: from per_position_extra_info
2741: where p_effective_date
2742: between fnd_date.canonical_to_date(poei_information3)
2743: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2744: and position_id = p_position_id
2745: and poei_information5 is not null
2746: and information_type= 'PER_RESERVED';
2747: begin

Line 3223: between fnd_date.canonical_to_date(poei_information3)

3219: cursor c1(p_position_id number, p_effective_date date, p_ex_position_extra_info_id number) is
3220: select sum(poei_information6) fte
3221: from per_position_extra_info
3222: where p_effective_date
3223: between fnd_date.canonical_to_date(poei_information3)
3224: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3225: and position_id = p_position_id
3226: and information_type= 'PER_RESERVED'
3227: and position_extra_info_id <> l_ex_position_extra_info_id;

Line 3224: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

3220: select sum(poei_information6) fte
3221: from per_position_extra_info
3222: where p_effective_date
3223: between fnd_date.canonical_to_date(poei_information3)
3224: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3225: and position_id = p_position_id
3226: and information_type= 'PER_RESERVED'
3227: and position_extra_info_id <> l_ex_position_extra_info_id;
3228: begin

Line 3286: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date

3282: from per_position_extra_info
3283: where information_type= 'PER_RESERVED'
3284: and position_id = p_position_id
3285: and position_extra_info_id <> l_ex_position_extra_info_id
3286: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3287: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3288: >= p_effective_date
3289: and poei_information5 = asn.person_id);
3290: l_nonreserved_fte number:=0;

Line 3287: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

3283: where information_type= 'PER_RESERVED'
3284: and position_id = p_position_id
3285: and position_extra_info_id <> l_ex_position_extra_info_id
3286: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3287: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3288: >= p_effective_date
3289: and poei_information5 = asn.person_id);
3290: l_nonreserved_fte number:=0;
3291: begin

Line 3484: fnd_date.canonical_to_date(poei_information3) poei_information3,

3480: query of the cursor as a fix of bug 5963148 **/
3481: cursor c_pos_reserved(p_position_id number, p_effective_date date) is
3482: select 'x'
3483: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3484: fnd_date.canonical_to_date(poei_information3) poei_information3,
3485: nvl(fnd_date.canonical_to_date(poei_information4),
3486: hr_general.end_of_time) poei_information4
3487: from per_position_extra_info
3488: where information_type = 'PER_RESERVED'

Line 3485: nvl(fnd_date.canonical_to_date(poei_information4),

3481: cursor c_pos_reserved(p_position_id number, p_effective_date date) is
3482: select 'x'
3483: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3484: fnd_date.canonical_to_date(poei_information3) poei_information3,
3485: nvl(fnd_date.canonical_to_date(poei_information4),
3486: hr_general.end_of_time) poei_information4
3487: from per_position_extra_info
3488: where information_type = 'PER_RESERVED'
3489: and position_id = p_position_id)

Line 3558: fnd_date.canonical_to_date(poei_information3) poei_information3,

3554: cursor c_pos_reserved(p_position_id number,
3555: p_effective_date date) is
3556: select 'x'
3557: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3558: fnd_date.canonical_to_date(poei_information3) poei_information3,
3559: nvl(fnd_date.canonical_to_date(poei_information4),
3560: hr_general.end_of_time) poei_information4
3561: from per_position_extra_info
3562: where information_type = 'PER_RESERVED'

Line 3559: nvl(fnd_date.canonical_to_date(poei_information4),

3555: p_effective_date date) is
3556: select 'x'
3557: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3558: fnd_date.canonical_to_date(poei_information3) poei_information3,
3559: nvl(fnd_date.canonical_to_date(poei_information4),
3560: hr_general.end_of_time) poei_information4
3561: from per_position_extra_info
3562: where information_type = 'PER_RESERVED'
3563: and position_id = p_position_id)

Line 3604: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date

3600: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3601: and asg.business_group_id = abv.business_group_id
3602: union
3603: select effective_start_date
3604: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date
3605: from per_position_extra_info
3606: where position_id = p_position_id
3607: and information_type = 'PER_RESERVED')
3608: where effective_start_date >= p_validation_start_date

Line 3645: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date

3641: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3642: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3643: union
3644: select effective_start_date
3645: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date
3646: from per_position_extra_info
3647: where position_id = p_position_id
3648: and information_type = 'PER_RESERVED')
3649: where effective_start_date >= p_validation_start_date

Line 4111: between fnd_date.canonical_to_date(poei_information3)

4107: from per_position_extra_info
4108: where information_type = 'PER_RESERVED'
4109: and position_id = p_position_id
4110: and p_effective_start_date
4111: between fnd_date.canonical_to_date(poei_information3)
4112: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4113: and poei_information5 is null;
4114: --
4115: --

Line 4112: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)

4108: where information_type = 'PER_RESERVED'
4109: and position_id = p_position_id
4110: and p_effective_start_date
4111: between fnd_date.canonical_to_date(poei_information3)
4112: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4113: and poei_information5 is null;
4114: --
4115: --
4116: CURSOR c_sum_asg_fte(p_position_id number) is

Line 4134: between fnd_date.canonical_to_date(poei.poei_information3)

4130: from per_position_extra_info poei
4131: where poei.information_type = 'PER_RESERVED'
4132: and poei.position_id = p_position_id
4133: and p_effective_start_date
4134: between fnd_date.canonical_to_date(poei.poei_information3)
4135: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4136: and to_number(poei.poei_information5) = asn.person_id);
4137: --
4138: l_blank_res_pos_fte number := 0;

Line 4135: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)

4131: where poei.information_type = 'PER_RESERVED'
4132: and poei.position_id = p_position_id
4133: and p_effective_start_date
4134: between fnd_date.canonical_to_date(poei.poei_information3)
4135: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4136: and to_number(poei.poei_information5) = asn.person_id);
4137: --
4138: l_blank_res_pos_fte number := 0;
4139: l_unreserved_fte number := 0;