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.HR_HRHD_RIR_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 1219: p_person_id per_all_assignments_f.person_id%type;

1215: myparameters wf_parameter_list_t;
1216: p_event_name varchar2(100);
1217: p_date date;
1218: -- data required for message
1219: p_person_id per_all_assignments_f.person_id%type;
1220: p_assignment_id per_all_assignments_f.assignment_id%type;
1221: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1222:
1223: begin

Line 1220: p_assignment_id per_all_assignments_f.assignment_id%type;

1216: p_event_name varchar2(100);
1217: p_date date;
1218: -- data required for message
1219: p_person_id per_all_assignments_f.person_id%type;
1220: p_assignment_id per_all_assignments_f.assignment_id%type;
1221: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1222:
1223: begin
1224:

Line 1221: p_eff_start_date per_all_assignments_f.effective_start_date%type;

1217: p_date date;
1218: -- data required for message
1219: p_person_id per_all_assignments_f.person_id%type;
1220: p_assignment_id per_all_assignments_f.assignment_id%type;
1221: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1222:
1223: begin
1224:
1225: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

Line 1331: p_person_id per_all_assignments_f.person_id%type;

1327: myparameters wf_parameter_list_t;
1328: p_event_name varchar2(100);
1329: p_date date;
1330: -- data required for message
1331: p_person_id per_all_assignments_f.person_id%type;
1332: p_assignment_id per_all_assignments_f.assignment_id%type;
1333: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1334:
1335: begin

Line 1332: p_assignment_id per_all_assignments_f.assignment_id%type;

1328: p_event_name varchar2(100);
1329: p_date date;
1330: -- data required for message
1331: p_person_id per_all_assignments_f.person_id%type;
1332: p_assignment_id per_all_assignments_f.assignment_id%type;
1333: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1334:
1335: begin
1336:

Line 1333: p_eff_start_date per_all_assignments_f.effective_start_date%type;

1329: p_date date;
1330: -- data required for message
1331: p_person_id per_all_assignments_f.person_id%type;
1332: p_assignment_id per_all_assignments_f.assignment_id%type;
1333: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1334:
1335: begin
1336:
1337: p_event_key := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'EVENT_KEY');

Line 1467: FROM per_all_assignments_f pas,

1463: case when (pas.person_id = pos.person_id and pas.effective_end_date = pos.actual_termination_date)
1464: then to_char(pos.ACTUAL_TERMINATION_DATE,''YYYY-MM-DD'')
1465: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,''YYYY-MM-DD'') end as "ACTUAL_TERMINATION_DATE"
1466:
1467: FROM per_all_assignments_f pas,
1468: per_periods_of_service pos,
1469: per_periods_of_placement pop
1470: WHERE pas.person_id = pop.person_id (+)
1471: AND pas.person_id = pos.person_id (+)

Line 2116: p_person_id per_all_assignments_f.person_id%type;

2112: p_date date;
2113: p_event_data clob;
2114:
2115: -- data required for message
2116: p_person_id per_all_assignments_f.person_id%type;
2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;

Line 2117: p_assignment_id per_all_assignments_f.assignment_id%type;

2113: p_event_data clob;
2114:
2115: -- data required for message
2116: p_person_id per_all_assignments_f.person_id%type;
2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;

Line 2118: p_assignment_number per_all_assignments_f.assignment_number%type;

2114:
2115: -- data required for message
2116: p_person_id per_all_assignments_f.person_id%type;
2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;

Line 2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;

2115: -- data required for message
2116: p_person_id per_all_assignments_f.person_id%type;
2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;

Line 2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;

2116: p_person_id per_all_assignments_f.person_id%type;
2117: p_assignment_id per_all_assignments_f.assignment_id%type;
2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;

Line 2122: p_probation_period per_all_assignments_f.probation_period%type;

2118: p_assignment_number per_all_assignments_f.assignment_number%type;
2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 2123: p_probation_units per_all_assignments_f.probation_unit%type;

2119: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;

Line 2124: p_organization_id per_all_assignments_f.organization_id%type;

2120: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;

Line 2125: p_job_id per_all_assignments_f.job_id%type;

2121: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;

Line 2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

2122: p_probation_period per_all_assignments_f.probation_period%type;
2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;

Line 2127: p_location_id per_all_assignments_f.location_id%type;

2123: p_probation_units per_all_assignments_f.probation_unit%type;
2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;

Line 2128: p_employment_category per_all_assignments_f.employment_category%type;

2124: p_organization_id per_all_assignments_f.organization_id%type;
2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;

Line 2129: p_business_group_id per_all_assignments_f.business_group_id%type;

2125: p_job_id per_all_assignments_f.job_id%type;
2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 2130: p_normal_hours per_all_assignments_f.normal_hours%type;

2126: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;

Line 2131: p_frequency per_all_assignments_f.frequency%type;

2127: p_location_id per_all_assignments_f.location_id%type;
2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;

Line 2132: p_grade_id per_all_assignments_f.grade_id%type;

2128: p_employment_category per_all_assignments_f.employment_category%type;
2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:

Line 2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;

2129: p_business_group_id per_all_assignments_f.business_group_id%type;
2130: p_normal_hours per_all_assignments_f.normal_hours%type;
2131: p_frequency per_all_assignments_f.frequency%type;
2132: p_grade_id per_all_assignments_f.grade_id%type;
2133: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:
2137: -- data required for message from table

Line 2138: p_person_id_t per_all_assignments_f.person_id%type;

2134: p_final_process_date per_periods_of_service.final_process_date%type;
2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:
2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;

Line 2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;

2135: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2136:
2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;

Line 2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;

2136:
2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;

Line 2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;

2137: -- data required for message from table
2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;

Line 2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;

2138: p_person_id_t per_all_assignments_f.person_id%type;
2139: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;

Line 2144: p_probation_period_t per_all_assignments_f.probation_period%type;

2140: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;

Line 2145: p_probation_units_t per_all_assignments_f.probation_unit%type;

2141: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;

Line 2146: p_organization_id_t per_all_assignments_f.organization_id%type;

2142: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;

Line 2147: p_job_id_t per_all_assignments_f.job_id%type;

2143: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;

Line 2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;

2144: p_probation_period_t per_all_assignments_f.probation_period%type;
2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;

Line 2149: p_location_id_t per_all_assignments_f.location_id%type;

2145: p_probation_units_t per_all_assignments_f.probation_unit%type;
2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;

Line 2150: p_employment_category_t per_all_assignments_f.employment_category%type;

2146: p_organization_id_t per_all_assignments_f.organization_id%type;
2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;

Line 2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;

2147: p_job_id_t per_all_assignments_f.job_id%type;
2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;

Line 2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;

2148: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;

Line 2153: p_frequency_t per_all_assignments_f.frequency%type;

2149: p_location_id_t per_all_assignments_f.location_id%type;
2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;
2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;

Line 2154: p_grade_id_t per_all_assignments_f.grade_id%type;

2150: p_employment_category_t per_all_assignments_f.employment_category%type;
2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;
2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2158:

Line 2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;

2151: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2152: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2153: p_frequency_t per_all_assignments_f.frequency%type;
2154: p_grade_id_t per_all_assignments_f.grade_id%type;
2155: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2156: p_final_process_date_t per_periods_of_service.final_process_date%type;
2157: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2158:
2159: cursor csr_fet_assignment(p_ass_id number,p_effst_date date)

Line 2189: per_all_assignments_f pas,

2185: then to_char(pos.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD')
2186: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,'YYYY-MM-DD') end
2187:
2188: FROM per_all_people_f ppf,
2189: per_all_assignments_f pas,
2190: per_periods_of_service pos,
2191: per_periods_of_placement pop
2192: WHERE pas.assignment_id = p_ass_id
2193: AND pas.person_id = ppf.person_id