APPS.PQH_PSF_BUS dependencies on PER_SHARED_TYPES

Line 2272: from per_shared_types

2268: --
2269: function GET_SYSTEM_SHARED_TYPE(p_availability_status_id number)
2270: return varchar2 is
2271: cursor c1 is select system_type_cd
2272: from per_shared_types
2273: where shared_type_id = p_availability_status_id;
2274: l_system_type varchar2(30);
2275: begin
2276: open c1;

Line 2307: per_shared_types where shared_type_id = p_unit_id;

2303: from hr_all_positions_f
2304: where position_id = p_position_id;
2305: --
2306: cursor c1(p_unit_id number) is select system_type_cd from
2307: per_shared_types where shared_type_id = p_unit_id;
2308: cursor c2(p_budget_id number) is select bdt.budget_detail_id
2309: from pqh_budget_details bdt,pqh_budget_versions bvr
2310: where bvr.budget_id = p_budget_id
2311: and p_effective_date between bvr.date_from and nvl(bvr.date_to,p_effective_date)

Line 2755: from per_shared_types

2751: l_budgeted_fte number;
2752:
2753: cursor c1(p_unit_id number) is
2754: select system_type_cd
2755: from per_shared_types
2756: where shared_type_id = p_unit_id;
2757:
2758: cursor c2(p_budget_id number) is
2759: select bdet.budget_detail_id

Line 3094: per_shared_types where shared_type_id = p_unit_id;

3090: from hr_all_positions_f
3091: where position_id = p_position_id;
3092: --
3093: cursor c1(p_unit_id number) is select system_type_cd from
3094: per_shared_types where shared_type_id = p_unit_id;
3095: cursor c2(p_budget_id number) is
3096: select bdt.budget_detail_id, bdt.budget_unit1_value, bdt.budget_unit2_value, bdt.budget_unit3_value
3097: from pqh_budget_details bdt,pqh_budget_versions bvr
3098: where bvr.budget_id = p_budget_id

Line 3187: per_shared_types where shared_type_id = p_unit_id;

3183: from hr_all_positions_f
3184: where position_id = p_position_id;
3185: --
3186: cursor c1(p_unit_id number) is select system_type_cd from
3187: per_shared_types where shared_type_id = p_unit_id;
3188: --
3189: begin
3190: hr_utility.set_location('inside chk_pos_budget',10);
3191: hr_utility.set_location('position_id is '||p_position_id,20);

Line 3314: per_shared_types where shared_type_id = p_unit_id;

3310: where assignment_id = p_assignment_id
3311: and p_effective_date between effective_start_date and effective_end_date;
3312: --
3313: cursor c1(p_unit_id number) is select system_type_cd from
3314: per_shared_types where shared_type_id = p_unit_id;
3315:
3316: begin
3317: begin
3318: open c_bus_grp_id(p_assignment_id);