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.PQP_GB_SWF_ARCHIVE dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 19: -- Set to 'N' if PQP_GB_SWF_CONTRACT_TYPE = , dates used from pqp_assignment_attributes_f

15: g_debug boolean;
16:
17: --
18: -- Set to 'Y' if PQP_GB_SWF_CONTRACT_TYPE = ASG_CAT, dates used from per_all_assignments_f
19: -- Set to 'N' if PQP_GB_SWF_CONTRACT_TYPE = , dates used from pqp_assignment_attributes_f
20: g_pick_from_asg varchar2(10);
21: --
22: g_teacher_sql_str varchar2(3000);
23: g_teach_dff_name varchar2(30);

Line 909: pqp_assignment_attributes_f att,

905: cursor csr_contract (p_asg_set_id number)
906: is
907: select distinct asg.assignment_id,asg.person_id
908: from per_all_assignments_f asg,
909: pqp_assignment_attributes_f att,
910: hr_location_extra_info hlei,
911: per_people_extra_info pei,
912: (select min(att1.effective_start_date) effective_start_date,
913: max(att1.effective_end_date) effective_end_date,

Line 915: from pqp_assignment_attributes_f att1

911: per_people_extra_info pei,
912: (select min(att1.effective_start_date) effective_start_date,
913: max(att1.effective_end_date) effective_end_date,
914: att1.assignment_id
915: from pqp_assignment_attributes_f att1
916: group by assignment_id ) min_max,
917:
918: (select first_value(location_id)over( partition by assignment_id order by asg1.effective_end_date desc ) location_id,
919: asg1.assignment_id

Line 1263: pqp_assignment_attributes_f att

1259:
1260: cursor csr_cont_eff_date_contract is
1261: select max(effective_end_date)
1262: from pay_assignment_actions act,
1263: pqp_assignment_attributes_f att
1264: where act.assignment_action_id = p_assactid
1265: and act.assignment_id = att.assignment_id;
1266:
1267: cursor get_person_id(p_effective_date date) is

Line 2060: pqp_assignment_attributes_f att

2056:
2057: cursor get_asg_contract_details is
2058: select att.contract_type,work_pattern
2059: from per_all_assignments_f paa,
2060: pqp_assignment_attributes_f att
2061: where paa.assignment_id = p_assignment_id
2062: and paa.assignment_id = att.assignment_id
2063: and p_effective_date between att.effective_start_date and att.effective_end_date
2064: and p_effective_date between paa.effective_start_date and paa.effective_end_date;

Line 2121: l_contract_type pqp_assignment_attributes_f.contract_type%type;

2117: and p_effective_date between effective_end_date and effective_start_date;
2118:
2119: l_proc constant varchar2(50) := g_package || ' fetch_hours_details';
2120: l_hrs_details_rec get_hrs_details%rowtype;
2121: l_contract_type pqp_assignment_attributes_f.contract_type%type;
2122: l_assignment_number per_all_assignments_f.assignment_number%type;
2123: l_hrs_src pqp_configuration_values.pcv_information1%type;
2124: l_hours_per_week varchar2(20);
2125: l_weeks_per_yr varchar2(20);

Line 2126: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;

2122: l_assignment_number per_all_assignments_f.assignment_number%type;
2123: l_hrs_src pqp_configuration_values.pcv_information1%type;
2124: l_hours_per_week varchar2(20);
2125: l_weeks_per_yr varchar2(20);
2126: l_work_pattern pqp_assignment_attributes_f.work_pattern%type;
2127: l_frequency per_all_assignments_f.frequency%type;
2128: l_no_of_hrs per_all_assignments_f.normal_hours%type;
2129: l_person_id per_all_assignments_f.person_id%type;
2130: l_no_of_days_per_wk number;

Line 2725: pqp_assignment_attributes_f att

2721: paa.employee_category employee_cat,
2722: paa.employment_category assignment_cat
2723: from per_all_assignments_f paa,
2724: pay_assignment_actions act,
2725: pqp_assignment_attributes_f att
2726: where act.assignment_action_id = p_assactid
2727: and act.assignment_id = att.assignment_id
2728: and paa.assignment_id = att.assignment_id
2729: and p_effective_date between att.effective_start_date and att.effective_end_date

Line 2740: from pqp_assignment_attributes_f att,

2736: to_char(min(att.effective_start_date) ,'YYYY-MM-DD') contract_st_date_dcsf,
2737: decode(to_char(max(att.effective_end_date) ,'YYYY-MM-DD'),'4712-12-31',null,
2738: to_char(max(att.effective_end_date) ,'YYYY-MM-DD'))contract_end_date_dcsf,
2739: to_char(min(paa.effective_start_date) ,'YYYY-MM-DD') date_of_arrival_dcsf
2740: from pqp_assignment_attributes_f att,
2741: per_all_assignments_f paa
2742: where att.assignment_id = p_assignment_id
2743: and paa.assignment_id = att.assignment_id;
2744:

Line 2784: cursor get_pqp_contract_type_dcsf(p_pqp_cont_type in pqp_assignment_attributes_f.contract_type%type ) is

2780: from per_people_extra_info pei
2781: where pei.information_type = 'PQP_SCHOOL_WORKFORCE_CENSUS'
2782: and pei.person_id = p_person_id;
2783:
2784: cursor get_pqp_contract_type_dcsf(p_pqp_cont_type in pqp_assignment_attributes_f.contract_type%type ) is
2785: select pcv_information5
2786: from pqp_configuration_values pcv
2787: where pcv.pcv_information_category = 'PQP_GB_SWF_CONTRACT_TYPE'
2788: and pcv_information4 = p_pqp_cont_type

Line 3663: from pqp_assignment_attributes_f

3659: and pcv.business_group_id = g_business_group_id;
3660:
3661: cursor safe_grd_sal is
3662: select decode(tp_safeguarded_rate_type,'SN','True','SP','True','G','True','False')
3663: from pqp_assignment_attributes_f
3664: where assignment_id= p_assignment_id;
3665: ---
3666: l_proc constant varchar2(50) := g_package || ' fetch_payment_details';
3667: l_regional_spine_context varchar2(30);