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 HR_ALL_POSITIONS_F

Line 661: from hr_all_positions_f

657: and abv.effective_end_date between p_validation_start_date and p_validation_end_date
658: and asg.effective_end_date between p_validation_start_date and p_validation_end_date
659: union
660: select effective_start_date, business_group_id
661: from hr_all_positions_f
662: where position_id = p_position_id
663: and effective_start_date between p_validation_start_date and p_validation_end_date;
664: --
665: cursor c_position_id(p_assignment_id number, p_effective_date date) is

Line 673: from hr_all_positions_f

669: and p_effective_date between effective_start_date and effective_end_date;
670: --
671: cursor c_position_fte(p_position_id number, p_date date) is
672: select overlap_period, fte, organization_id
673: from hr_all_positions_f
674: where position_id = p_position_id
675: and p_date between effective_start_date and effective_end_date;
676: --
677: begin

Line 766: l_position_id hr_all_positions_f.position_id%type;

762: p_value number,
763: p_unit varchar2,
764: p_effective_date date) is
765: l_proc varchar2(100) := 'per_abv_insert_validate';
766: l_position_id hr_all_positions_f.position_id%type;
767: l_fte hr_all_positions_f.fte%type;
768: l_max_persons hr_all_positions_f.max_persons%type;
769: l_position_type hr_all_positions_f.position_type%type;
770: l_organization_id number;

Line 767: l_fte hr_all_positions_f.fte%type;

763: p_unit varchar2,
764: p_effective_date date) is
765: l_proc varchar2(100) := 'per_abv_insert_validate';
766: l_position_id hr_all_positions_f.position_id%type;
767: l_fte hr_all_positions_f.fte%type;
768: l_max_persons hr_all_positions_f.max_persons%type;
769: l_position_type hr_all_positions_f.position_type%type;
770: l_organization_id number;
771: l_sum_abv number:=0;

Line 768: l_max_persons hr_all_positions_f.max_persons%type;

764: p_effective_date date) is
765: l_proc varchar2(100) := 'per_abv_insert_validate';
766: l_position_id hr_all_positions_f.position_id%type;
767: l_fte hr_all_positions_f.fte%type;
768: l_max_persons hr_all_positions_f.max_persons%type;
769: l_position_type hr_all_positions_f.position_type%type;
770: l_organization_id number;
771: l_sum_abv number:=0;
772: l_pos_budget_fte number:=0;

Line 769: l_position_type hr_all_positions_f.position_type%type;

765: l_proc varchar2(100) := 'per_abv_insert_validate';
766: l_position_id hr_all_positions_f.position_id%type;
767: l_fte hr_all_positions_f.fte%type;
768: l_max_persons hr_all_positions_f.max_persons%type;
769: l_position_type hr_all_positions_f.position_type%type;
770: l_organization_id number;
771: l_sum_abv number:=0;
772: l_pos_budget_fte number:=0;
773: l_person_id number;

Line 790: from hr_all_positions_f psf

786: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
787:
788: cursor c_positions is
789: select position_id, fte, max_persons, position_type, organization_id, overlap_period
790: from hr_all_positions_f psf
791: where position_id =
792: (select position_id
793: from per_all_assignments_f paf
794: where paf.assignment_id = p_assignment_id

Line 921: l_position_id hr_all_positions_f.position_id%type;

917: p_validation_start_date date,
918: p_validation_end_date date,
919: p_datetrack_mode varchar2) is
920: l_proc varchar2(100) := 'per_abv_update_validate';
921: l_position_id hr_all_positions_f.position_id%type;
922: l_fte hr_all_positions_f.fte%type;
923: l_max_persons hr_all_positions_f.max_persons%type;
924: l_position_type hr_all_positions_f.position_type%type;
925: l_organization_id number;

Line 922: l_fte hr_all_positions_f.fte%type;

918: p_validation_end_date date,
919: p_datetrack_mode varchar2) is
920: l_proc varchar2(100) := 'per_abv_update_validate';
921: l_position_id hr_all_positions_f.position_id%type;
922: l_fte hr_all_positions_f.fte%type;
923: l_max_persons hr_all_positions_f.max_persons%type;
924: l_position_type hr_all_positions_f.position_type%type;
925: l_organization_id number;
926: l_sum_abv number;

Line 923: l_max_persons hr_all_positions_f.max_persons%type;

919: p_datetrack_mode varchar2) is
920: l_proc varchar2(100) := 'per_abv_update_validate';
921: l_position_id hr_all_positions_f.position_id%type;
922: l_fte hr_all_positions_f.fte%type;
923: l_max_persons hr_all_positions_f.max_persons%type;
924: l_position_type hr_all_positions_f.position_type%type;
925: l_organization_id number;
926: l_sum_abv number;
927: l_pos_budget_fte number;

Line 924: l_position_type hr_all_positions_f.position_type%type;

920: l_proc varchar2(100) := 'per_abv_update_validate';
921: l_position_id hr_all_positions_f.position_id%type;
922: l_fte hr_all_positions_f.fte%type;
923: l_max_persons hr_all_positions_f.max_persons%type;
924: l_position_type hr_all_positions_f.position_type%type;
925: l_organization_id number;
926: l_sum_abv number;
927: l_pos_budget_fte number;
928: l_person_id number;

Line 947: from hr_all_positions_f psf

943: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
944: --
945: cursor c_positions(p_effective_date date) is
946: select position_id, fte, max_persons, position_type, organization_id, overlap_period
947: from hr_all_positions_f psf
948: where position_id =
949: (select position_id
950: from per_all_assignments_f paf
951: where paf.assignment_id = p_assignment_id

Line 1369: from hr_all_positions_f

1365: l_funded_status varchar2(30);
1366:
1367: cursor c_positions is
1368: select availability_status_id, business_group_id, position_type, date_effective
1369: from hr_all_positions_f
1370: where position_id = p_position_id
1371: and p_effective_date between effective_start_date and effective_end_date;
1372: begin
1373: l_open_status := 'OPEN';

Line 1561: select position_type, FTE from hr_all_positions_f

1557: l_assignment_id number(15);
1558: l_sum_asg_fte number;
1559: --
1560: CURSOR C1 IS
1561: select position_type, FTE from hr_all_positions_f
1562: where position_id = p_position_id
1563: and p_effective_date
1564: between effective_start_date and effective_end_date;
1565:

Line 1918: from hr_all_positions_f

1914: function proposed_date_for_layoff(p_position_id number) return date is
1915: l_proposed_date_for_layoff date;
1916: cursor c1 is
1917: select proposed_date_for_layoff
1918: from hr_all_positions_f
1919: where position_id = p_position_id;
1920: begin
1921: open c1;
1922: fetch c1 into l_proposed_date_for_layoff;

Line 1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type

1975: close c1;
1976: return(l_work_period_type_cd);
1977: end ;
1978: --
1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type

Line 1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type

1976: return(l_work_period_type_cd);
1977: end ;
1978: --
1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type

Line 1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type

1977: end ;
1978: --
1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type

Line 1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type

1978: --
1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
1986: ) return boolean is

Line 1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type

1979: function chk_work_pay_term_dates(p_work_period_type_cd hr_all_positions_f.work_period_type_cd%type
1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
1986: ) return boolean is
1987: begin

Line 1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type

1980: ,p_work_term_end_day_cd hr_all_positions_f.work_term_end_day_cd%type
1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
1986: ) return boolean is
1987: begin
1988: if (p_work_period_type_cd = 'Y') then

Line 1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type

1981: ,p_work_term_end_month_cd hr_all_positions_f.work_term_end_month_cd%type
1982: ,p_pay_term_end_day_cd hr_all_positions_f.pay_term_end_day_cd%type
1983: ,p_pay_term_end_month_cd hr_all_positions_f.pay_term_end_month_cd%type
1984: ,p_term_start_day_cd hr_all_positions_f.term_start_day_cd%type
1985: ,p_term_start_month_cd hr_all_positions_f.term_start_month_cd%type
1986: ) return boolean is
1987: begin
1988: if (p_work_period_type_cd = 'Y') then
1989: return(true);

Line 2110: from hr_all_positions_f

2106: l_business_group_id number;
2107: --
2108: cursor c_bus_grp_id(p_position_id number) is
2109: select business_group_id
2110: from hr_all_positions_f
2111: where position_id = p_position_id;
2112: --
2113: cursor c1(p_unit_id number) is select system_type_cd from
2114: per_shared_types where shared_type_id = p_unit_id;

Line 2842: from hr_all_positions_f

2838: l_business_group_id number;
2839: --
2840: cursor c_bus_grp_id(p_position_id number) is
2841: select business_group_id
2842: from hr_all_positions_f
2843: where position_id = p_position_id;
2844: --
2845: cursor c1(p_unit_id number) is select system_type_cd from
2846: per_shared_types where shared_type_id = p_unit_id;

Line 2935: from hr_all_positions_f

2931: l_business_group_id number;
2932: --
2933: cursor c_bus_grp_id(p_position_id number) is
2934: select business_group_id
2935: from hr_all_positions_f
2936: where position_id = p_position_id;
2937: --
2938: cursor c1(p_unit_id number) is select system_type_cd from
2939: per_shared_types where shared_type_id = p_unit_id;

Line 3303: from hr_all_positions_f

3299: function position_fte(p_position_id number, p_effective_date date) return number is
3300: l_fte number;
3301: cursor c1(p_position_id number, p_effective_date date) is
3302: select fte
3303: from hr_all_positions_f
3304: where position_id = p_position_id
3305: and p_effective_date between effective_start_date and effective_end_date;
3306: begin
3307: open c1(p_position_id, p_effective_date);

Line 3384: from hr_all_positions_f psf

3380: and asg.effective_start_date between
3381: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3382: union
3383: select effective_start_date effective_date
3384: from hr_all_positions_f psf
3385: where position_id = p_position_id
3386: and psf.effective_start_date between
3387: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3388: union

Line 3397: from hr_all_positions_f

3393: from dual;
3394: --
3395: cursor c2(p_position_id number) is
3396: select business_group_id
3397: from hr_all_positions_f
3398: where position_id = p_position_id;
3399: --
3400: begin
3401: --

Line 3475: from hr_all_positions_f

3471: l_business_group_id number;
3472: --
3473: cursor c_pos_fte(p_position_id number, p_effective_date date) is
3474: select position_type, overlap_period, business_group_id
3475: from hr_all_positions_f
3476: where position_id = p_position_id
3477: and p_effective_date between effective_start_date and effective_end_date;
3478: ----
3479: /*** index hint added in the select statement of the inner

Line 3625: from hr_all_positions_f

3621: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3622: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3623: union
3624: select effective_start_date
3625: from hr_all_positions_f
3626: where position_id = p_position_id
3627: and effective_start_date between p_validation_start_date and p_validation_end_date;
3628: --
3629: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is

Line 3652: from hr_all_positions_f

3648: and information_type = 'PER_RESERVED')
3649: where effective_start_date >= p_validation_start_date
3650: union
3651: select effective_start_date
3652: from hr_all_positions_f
3653: where position_id = p_position_id
3654: and effective_start_date between p_validation_start_date and p_validation_end_date;
3655: --
3656: begin

Line 3713: from hr_all_positions_f

3709: l_business_group_id number;
3710: --
3711: cursor c_pos_fte(p_position_id number, p_effective_date date) is
3712: select position_type, fte, organization_id, overlap_period, business_group_id
3713: from hr_all_positions_f
3714: where position_id = p_position_id
3715: and p_effective_date between effective_start_date and effective_end_date;
3716: --
3717: begin

Line 3845: from hr_all_positions_f

3841: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3842: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3843: union
3844: select effective_start_date
3845: from hr_all_positions_f
3846: where position_id = p_position_id
3847: and effective_start_date between p_validation_start_date and p_validation_end_date;
3848: --
3849: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is

Line 3866: from hr_all_positions_f

3862: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
3863: and asg.business_group_id = abv.business_group_id
3864: union
3865: select effective_start_date
3866: from hr_all_positions_f
3867: where position_id = p_position_id
3868: and effective_start_date between p_validation_start_date and p_validation_end_date;
3869: --
3870: begin

Line 4065: from hr_all_positions_f

4061: l_business_group_id number;
4062: --
4063: cursor c2(p_position_id number, p_effective_date date) is
4064: select fte, business_group_id
4065: from hr_all_positions_f
4066: where position_id = p_position_id
4067: and p_effective_date
4068: between effective_start_date and effective_end_date;
4069: begin