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 1475: select fnd_date.canonical_to_date(poei_information3), fnd_date.canonical_to_date(poei_information4)

1471: from hr_all_positions
1472: where position_id = p_position_id;
1473:
1474: cursor c2 is
1475: select fnd_date.canonical_to_date(poei_information3), fnd_date.canonical_to_date(poei_information4)
1476: from per_position_extra_info
1477: where information_type = 'PER_OVERLAP'
1478: and position_id = p_position_id;
1479:

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

1509: l_fte_reserved number(15,2);
1510: l_person_id number(15);
1511:
1512: cursor c1 is
1513: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1514: nvl(fnd_date.canonical_to_date(poei_information4),
1515: hr_general.end_of_time) poei_information4,
1516: poei_information5, poei_information6, poei_information7
1517: from per_position_extra_info

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

1510: l_person_id number(15);
1511:
1512: cursor c1 is
1513: select fnd_date.canonical_to_date(poei_information3) poei_information3,
1514: nvl(fnd_date.canonical_to_date(poei_information4),
1515: hr_general.end_of_time) poei_information4,
1516: poei_information5, poei_information6, poei_information7
1517: from per_position_extra_info
1518: where position_id = p_position_id

Line 1741: between fnd_date.canonical_to_date(poei_information3)

1737: -- Start changes for bug 10220040
1738: /*select 'x'
1739: from per_position_extra_info
1740: where p_assignment_start_date
1741: between fnd_date.canonical_to_date(poei_information3)
1742: and fnd_date.canonical_to_date(poei_information4)
1743: -- Start changes for bug 10220040
1744: and p_assignment_end_date
1745: between fnd_date.canonical_to_date(poei_information3)

Line 1742: and fnd_date.canonical_to_date(poei_information4)

1738: /*select 'x'
1739: from per_position_extra_info
1740: where p_assignment_start_date
1741: between fnd_date.canonical_to_date(poei_information3)
1742: and fnd_date.canonical_to_date(poei_information4)
1743: -- Start changes for bug 10220040
1744: and p_assignment_end_date
1745: between fnd_date.canonical_to_date(poei_information3)
1746: and fnd_date.canonical_to_date(poei_information4)

Line 1745: between fnd_date.canonical_to_date(poei_information3)

1741: between fnd_date.canonical_to_date(poei_information3)
1742: and fnd_date.canonical_to_date(poei_information4)
1743: -- Start changes for bug 10220040
1744: and p_assignment_end_date
1745: between fnd_date.canonical_to_date(poei_information3)
1746: and fnd_date.canonical_to_date(poei_information4)
1747: -- End changes for bug 10220040
1748: and position_id = p_position_id
1749: and information_type = 'PER_OVERLAP';*/

Line 1746: and fnd_date.canonical_to_date(poei_information4)

1742: and fnd_date.canonical_to_date(poei_information4)
1743: -- Start changes for bug 10220040
1744: and p_assignment_end_date
1745: between fnd_date.canonical_to_date(poei_information3)
1746: and fnd_date.canonical_to_date(poei_information4)
1747: -- End changes for bug 10220040
1748: and position_id = p_position_id
1749: and information_type = 'PER_OVERLAP';*/
1750: select

Line 1751: fnd_date.canonical_to_date(poei_information3) effective_start_date,

1747: -- End changes for bug 10220040
1748: and position_id = p_position_id
1749: and information_type = 'PER_OVERLAP';*/
1750: select
1751: fnd_date.canonical_to_date(poei_information3) effective_start_date,
1752: fnd_date.canonical_to_date(poei_information4) effective_end_date
1753: from (
1754: select poei_information3, poei_information4
1755: from per_position_extra_info

Line 1752: fnd_date.canonical_to_date(poei_information4) effective_end_date

1748: and position_id = p_position_id
1749: and information_type = 'PER_OVERLAP';*/
1750: select
1751: fnd_date.canonical_to_date(poei_information3) effective_start_date,
1752: fnd_date.canonical_to_date(poei_information4) effective_end_date
1753: from (
1754: select poei_information3, poei_information4
1755: from per_position_extra_info
1756: where information_type = 'PER_OVERLAP'

Line 1759: between fnd_date.canonical_to_date(poei_information3)

1755: from per_position_extra_info
1756: where information_type = 'PER_OVERLAP'
1757: and position_id = p_position_id)
1758: where p_assignment_start_date
1759: between fnd_date.canonical_to_date(poei_information3)
1760: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
1761: order by 1,2 desc;
1762:
1763: cursor c_position_type is

Line 1760: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))

1756: where information_type = 'PER_OVERLAP'
1757: and position_id = p_position_id)
1758: where p_assignment_start_date
1759: between fnd_date.canonical_to_date(poei_information3)
1760: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
1761: order by 1,2 desc;
1762:
1763: cursor c_position_type is
1764: select position_type

Line 2857: between fnd_date.canonical_to_date(poei_information3)

2853: cursor c1(p_person_id number, p_position_id number, p_effective_date date) is
2854: select to_number(poei_information6,'99999999.99') fte
2855: from per_position_extra_info
2856: where p_effective_date
2857: between fnd_date.canonical_to_date(poei_information3)
2858: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2859: and position_id = p_position_id
2860: and information_type= 'PER_RESERVED'
2861: and poei_information5 = p_person_id;

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

2854: select to_number(poei_information6,'99999999.99') fte
2855: from per_position_extra_info
2856: where p_effective_date
2857: between fnd_date.canonical_to_date(poei_information3)
2858: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2859: and position_id = p_position_id
2860: and information_type= 'PER_RESERVED'
2861: and poei_information5 = p_person_id;
2862: *******/

Line 2871: where p_effective_date between fnd_date.canonical_to_date(poei_information3)

2867: (SELECT poei_information6, poei_information3, poei_information4, ROWNUM rn from per_position_extra_info
2868: WHERE position_id = p_position_id
2869: and information_type= 'PER_RESERVED'
2870: and poei_information5 = p_person_id) pos
2871: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2872: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2873:
2874: begin
2875: hr_utility.set_location('inside reserved_fte',10);

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

2868: WHERE position_id = p_position_id
2869: and information_type= 'PER_RESERVED'
2870: and poei_information5 = p_person_id) pos
2871: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2872: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2873:
2874: begin
2875: hr_utility.set_location('inside reserved_fte',10);
2876: if p_person_id is not null and p_position_id is not null and p_effective_date is not null then

Line 2910: between fnd_date.canonical_to_date(poei_information3)

2906: cursor c1(p_position_id number, p_effective_date date) is
2907: select sum(to_number(poei_information6,'99999999.99')) fte
2908: from per_position_extra_info
2909: where p_effective_date
2910: between fnd_date.canonical_to_date(poei_information3)
2911: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2912: and position_id = p_position_id
2913: and information_type= 'PER_RESERVED';
2914: *********/

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

2907: select sum(to_number(poei_information6,'99999999.99')) fte
2908: from per_position_extra_info
2909: where p_effective_date
2910: between fnd_date.canonical_to_date(poei_information3)
2911: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2912: and position_id = p_position_id
2913: and information_type= 'PER_RESERVED';
2914: *********/
2915: cursor c1(p_position_id number, p_effective_date date) is

Line 2920: where p_effective_date between fnd_date.canonical_to_date(poei_information3)

2916: select sum(to_number(poei_information6,'99999999.99')) fte
2917: from ( SELECT poei_information6,poei_information3,poei_information4, ROWNUM rn from per_position_extra_info
2918: WHERE position_id = p_position_id
2919: and information_type= 'PER_RESERVED') pos
2920: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2921: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2922:
2923: --
2924: begin

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

2917: from ( SELECT poei_information6,poei_information3,poei_information4, ROWNUM rn from per_position_extra_info
2918: WHERE position_id = p_position_id
2919: and information_type= 'PER_RESERVED') pos
2920: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2921: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2922:
2923: --
2924: begin
2925: hr_utility.set_location('inside unreserved_fte',10);

Line 2973: between fnd_date.canonical_to_date(poei_information3)

2969: cursor c1(p_position_id number, p_effective_date date) is
2970: select poei_information5 person_id
2971: from per_position_extra_info
2972: where p_effective_date
2973: between fnd_date.canonical_to_date(poei_information3)
2974: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2975: and position_id = p_position_id
2976: and poei_information5 is not null
2977: and information_type= 'PER_RESERVED';

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

2970: select poei_information5 person_id
2971: from per_position_extra_info
2972: where p_effective_date
2973: between fnd_date.canonical_to_date(poei_information3)
2974: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
2975: and position_id = p_position_id
2976: and poei_information5 is not null
2977: and information_type= 'PER_RESERVED';
2978: *********/

Line 2986: where p_effective_date between fnd_date.canonical_to_date(poei_information3)

2982: FROM per_position_extra_info
2983: WHERE position_id = p_position_id
2984: and poei_information5 is not null
2985: and information_type= 'PER_RESERVED') pos
2986: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2987: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2988:
2989: begin
2990: hr_utility.set_location('inside reserved_overused ',10);

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

2983: WHERE position_id = p_position_id
2984: and poei_information5 is not null
2985: and information_type= 'PER_RESERVED') pos
2986: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
2987: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
2988:
2989: begin
2990: hr_utility.set_location('inside reserved_overused ',10);
2991: if p_position_id is not null and p_effective_date is not null then

Line 3474: between fnd_date.canonical_to_date(poei_information3)

3470: cursor c1(p_position_id number, p_effective_date date, p_ex_position_extra_info_id number) is
3471: select sum(poei_information6) fte
3472: from per_position_extra_info
3473: where p_effective_date
3474: between fnd_date.canonical_to_date(poei_information3)
3475: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3476: and position_id = p_position_id
3477: and information_type= 'PER_RESERVED'
3478: and position_extra_info_id <> l_ex_position_extra_info_id;

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

3471: select sum(poei_information6) fte
3472: from per_position_extra_info
3473: where p_effective_date
3474: between fnd_date.canonical_to_date(poei_information3)
3475: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
3476: and position_id = p_position_id
3477: and information_type= 'PER_RESERVED'
3478: and position_extra_info_id <> l_ex_position_extra_info_id;
3479: *********/

Line 3487: where p_effective_date between fnd_date.canonical_to_date(poei_information3)

3483: FROM per_position_extra_info
3484: WHERE position_id = p_position_id
3485: and information_type= 'PER_RESERVED'
3486: and position_extra_info_id <> l_ex_position_extra_info_id) pei
3487: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
3488: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3489:
3490: begin
3491: hr_utility.set_location('inside pos_reserved_fte',10);

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

3484: WHERE position_id = p_position_id
3485: and information_type= 'PER_RESERVED'
3486: and position_extra_info_id <> l_ex_position_extra_info_id) pei
3487: where p_effective_date between fnd_date.canonical_to_date(poei_information3)
3488: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3489:
3490: begin
3491: hr_utility.set_location('inside pos_reserved_fte',10);
3492: if p_position_id is not null and p_effective_date is not null then

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

3549: FROM per_position_extra_info
3550: where information_type= 'PER_RESERVED'
3551: and position_id = p_position_id ) pei
3552: where position_extra_info_id <> l_ex_position_extra_info_id
3553: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3554: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time) >= p_effective_date
3555: and poei_information5 = asn.person_id);
3556: l_nonreserved_fte number:=0;
3557: begin

Line 3554: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time) >= p_effective_date

3550: where information_type= 'PER_RESERVED'
3551: and position_id = p_position_id ) pei
3552: where position_extra_info_id <> l_ex_position_extra_info_id
3553: and fnd_date.canonical_to_date(poei_information3) <= p_effective_date
3554: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time) >= p_effective_date
3555: and poei_information5 = asn.person_id);
3556: l_nonreserved_fte number:=0;
3557: begin
3558: hr_utility.set_location('inside nonreserved_asg_fte',10);

Line 3787: fnd_date.canonical_to_date(poei_information3)

3783: where information_type = 'PER_RESERVED'
3784: and position_id = p_position_id)
3785: where p_effective_date
3786: between
3787: fnd_date.canonical_to_date(poei_information3)
3788: and
3789: nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3790: -- End changes for bug 10262123
3791:

Line 3789: nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

3785: where p_effective_date
3786: between
3787: fnd_date.canonical_to_date(poei_information3)
3788: and
3789: nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
3790: -- End changes for bug 10262123
3791:
3792: --
3793: begin

Line 3865: fnd_date.canonical_to_date(poei_information3) poei_information3,

3861: cursor c_pos_reserved(p_position_id number,
3862: p_effective_date date) is
3863: select 'x'
3864: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3865: fnd_date.canonical_to_date(poei_information3) poei_information3,
3866: nvl(fnd_date.canonical_to_date(poei_information4),
3867: hr_general.end_of_time) poei_information4
3868: from per_position_extra_info
3869: where information_type = 'PER_RESERVED'

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

3862: p_effective_date date) is
3863: select 'x'
3864: from (select /*+ INDEX(PER_POSITION_EXTRA_INFO PER_POSITION_EXTRA_INFO_N3)*/
3865: fnd_date.canonical_to_date(poei_information3) poei_information3,
3866: nvl(fnd_date.canonical_to_date(poei_information4),
3867: hr_general.end_of_time) poei_information4
3868: from per_position_extra_info
3869: where information_type = 'PER_RESERVED'
3870: and position_id = p_position_id)

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

3909: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3910: and asg.business_group_id = abv.business_group_id
3911: union
3912: select effective_start_date
3913: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date
3914: from per_position_extra_info
3915: where position_id = p_position_id
3916: and information_type = 'PER_RESERVED')
3917: where effective_start_date >= p_validation_start_date

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

3950: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3951: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3952: union
3953: select effective_start_date
3954: from (select fnd_date.canonical_to_date(poei_information3) effective_start_date
3955: from per_position_extra_info
3956: where position_id = p_position_id
3957: and information_type = 'PER_RESERVED')
3958: where effective_start_date >= p_validation_start_date

Line 4490: between fnd_date.canonical_to_date(poei_information3)

4486: FROM per_position_extra_info
4487: where information_type = 'PER_RESERVED'
4488: and position_id = p_position_id ) poei
4489: Where p_effective_start_date
4490: between fnd_date.canonical_to_date(poei_information3)
4491: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4492: and poei_information5 is null;
4493: --
4494: --

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

4487: where information_type = 'PER_RESERVED'
4488: and position_id = p_position_id ) poei
4489: Where p_effective_start_date
4490: between fnd_date.canonical_to_date(poei_information3)
4491: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time)
4492: and poei_information5 is null;
4493: --
4494: --
4495: CURSOR c_sum_asg_fte(p_position_id number) is

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

4510: FROM per_position_extra_info
4511: where information_type = 'PER_RESERVED'
4512: and position_id = p_position_id) poei
4513: where p_effective_start_date
4514: between fnd_date.canonical_to_date(poei.poei_information3)
4515: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4516: and to_number(poei.poei_information5) = asn.person_id);
4517: --
4518: l_blank_res_pos_fte number := 0;

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

4511: where information_type = 'PER_RESERVED'
4512: and position_id = p_position_id) poei
4513: where p_effective_start_date
4514: between fnd_date.canonical_to_date(poei.poei_information3)
4515: and nvl(fnd_date.canonical_to_date(poei.poei_information4),hr_general.end_of_time)
4516: and to_number(poei.poei_information5) = asn.person_id);
4517: --
4518: l_blank_res_pos_fte number := 0;
4519: l_unreserved_fte number := 0;