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 755: from per_all_assignments_f

751: l_transaction_id_canonical Varchar2(30);
752:
753: cursor csr_asg_id(p_person_id varchar2,p_date date) is
754: select distinct assignment_id
755: from per_all_assignments_f
756: where person_id = p_person_id
757: and trunc(effective_start_date) = trunc(p_date);
758:
759:

Line 927: p_assignment_id per_all_assignments_f.assignment_id%type;

923: p_at_date varchar2(100);
924: p_act_term_date date;
925: p_event_name varchar2(100);
926:
927: p_assignment_id per_all_assignments_f.assignment_id%type;
928: p_eff_start_date per_all_assignments_f.effective_start_date%type;
929: p_assignment_data clob;
930:
931: l_transaction_id Number;

Line 928: p_eff_start_date per_all_assignments_f.effective_start_date%type;

924: p_act_term_date date;
925: p_event_name varchar2(100);
926:
927: p_assignment_id per_all_assignments_f.assignment_id%type;
928: p_eff_start_date per_all_assignments_f.effective_start_date%type;
929: p_assignment_data clob;
930:
931: l_transaction_id Number;
932: l_transaction_id_canonical Varchar2(30);

Line 944: from per_all_assignments_f

940: /*code added for 8424994*/
941:
942: cursor csr_asg_id(p_person_id varchar2,p_date date) is
943: select distinct assignment_id
944: from per_all_assignments_f
945: where person_id = p_person_id
946: and p_date between effective_start_date and effective_end_date;
947:
948: /*code added for 8424994*/

Line 1383: p_person_id per_all_assignments_f.person_id%type;

1379: myparameters wf_parameter_list_t;
1380: p_event_name varchar2(100);
1381: p_date date;
1382: -- data required for message
1383: p_person_id per_all_assignments_f.person_id%type;
1384: p_assignment_id per_all_assignments_f.assignment_id%type;
1385: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1386:
1387: l_transaction_id Number :=0;

Line 1384: p_assignment_id per_all_assignments_f.assignment_id%type;

1380: p_event_name varchar2(100);
1381: p_date date;
1382: -- data required for message
1383: p_person_id per_all_assignments_f.person_id%type;
1384: p_assignment_id per_all_assignments_f.assignment_id%type;
1385: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1386:
1387: l_transaction_id Number :=0;
1388: l_transaction_id_canonical Varchar2(30);

Line 1385: p_eff_start_date per_all_assignments_f.effective_start_date%type;

1381: p_date date;
1382: -- data required for message
1383: p_person_id per_all_assignments_f.person_id%type;
1384: p_assignment_id per_all_assignments_f.assignment_id%type;
1385: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1386:
1387: l_transaction_id Number :=0;
1388: l_transaction_id_canonical Varchar2(30);
1389:

Line 1502: p_person_id per_all_assignments_f.person_id%type;

1498: myparameters wf_parameter_list_t;
1499: p_event_name varchar2(100);
1500: p_date date;
1501: -- data required for message
1502: p_person_id per_all_assignments_f.person_id%type;
1503: p_assignment_id per_all_assignments_f.assignment_id%type;
1504: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1505:
1506: l_transaction_id Number :=0;

Line 1503: p_assignment_id per_all_assignments_f.assignment_id%type;

1499: p_event_name varchar2(100);
1500: p_date date;
1501: -- data required for message
1502: p_person_id per_all_assignments_f.person_id%type;
1503: p_assignment_id per_all_assignments_f.assignment_id%type;
1504: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1505:
1506: l_transaction_id Number :=0;
1507: l_transaction_id_canonical Varchar2(30);

Line 1504: p_eff_start_date per_all_assignments_f.effective_start_date%type;

1500: p_date date;
1501: -- data required for message
1502: p_person_id per_all_assignments_f.person_id%type;
1503: p_assignment_id per_all_assignments_f.assignment_id%type;
1504: p_eff_start_date per_all_assignments_f.effective_start_date%type;
1505:
1506: l_transaction_id Number :=0;
1507: l_transaction_id_canonical Varchar2(30);
1508:

Line 1647: FROM per_all_assignments_f pas,

1643: 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",
1644:
1645: primary_flag as "PRIMARY_FLAG"
1646:
1647: FROM per_all_assignments_f pas,
1648: per_periods_of_service pos,
1649: per_periods_of_placement pop
1650: WHERE pas.person_id = pop.person_id (+)
1651: AND pas.person_id = pos.person_id (+)

Line 2299: p_person_id per_all_assignments_f.person_id%type;

2295: p_date date;
2296: p_event_data clob;
2297:
2298: -- data required for message
2299: p_person_id per_all_assignments_f.person_id%type;
2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;

Line 2300: p_assignment_id per_all_assignments_f.assignment_id%type;

2296: p_event_data clob;
2297:
2298: -- data required for message
2299: p_person_id per_all_assignments_f.person_id%type;
2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;

Line 2301: p_assignment_number per_all_assignments_f.assignment_number%type;

2297:
2298: -- data required for message
2299: p_person_id per_all_assignments_f.person_id%type;
2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;

Line 2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;

2298: -- data required for message
2299: p_person_id per_all_assignments_f.person_id%type;
2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;

Line 2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;

2299: p_person_id per_all_assignments_f.person_id%type;
2300: p_assignment_id per_all_assignments_f.assignment_id%type;
2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;

Line 2305: p_probation_period per_all_assignments_f.probation_period%type;

2301: p_assignment_number per_all_assignments_f.assignment_number%type;
2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 2306: p_probation_units per_all_assignments_f.probation_unit%type;

2302: p_eff_start_date per_all_assignments_f.effective_start_date%type;
2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;

Line 2307: p_organization_id per_all_assignments_f.organization_id%type;

2303: p_eff_end_Date per_all_assignments_f.effective_end_date%type;
2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;

Line 2308: p_job_id per_all_assignments_f.job_id%type;

2304: p_original_date_of_hire per_all_people_f.original_date_of_hire%type;
2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;

Line 2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

2305: p_probation_period per_all_assignments_f.probation_period%type;
2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;

Line 2310: p_location_id per_all_assignments_f.location_id%type;

2306: p_probation_units per_all_assignments_f.probation_unit%type;
2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;

Line 2311: p_employment_category per_all_assignments_f.employment_category%type;

2307: p_organization_id per_all_assignments_f.organization_id%type;
2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;

Line 2312: p_business_group_id per_all_assignments_f.business_group_id%type;

2308: p_job_id per_all_assignments_f.job_id%type;
2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 2313: p_normal_hours per_all_assignments_f.normal_hours%type;

2309: p_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;

Line 2314: p_frequency per_all_assignments_f.frequency%type;

2310: p_location_id per_all_assignments_f.location_id%type;
2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;

Line 2315: p_grade_id per_all_assignments_f.grade_id%type;

2311: p_employment_category per_all_assignments_f.employment_category%type;
2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;

Line 2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;

2312: p_business_group_id per_all_assignments_f.business_group_id%type;
2313: p_normal_hours per_all_assignments_f.normal_hours%type;
2314: p_frequency per_all_assignments_f.frequency%type;
2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:

Line 2319: p_primary_flag per_all_assignments_f.primary_flag%type;

2315: p_grade_id per_all_assignments_f.grade_id%type;
2316: p_supervisor_id per_all_assignments_f.supervisor_id%type;
2317: p_final_process_date per_periods_of_service.final_process_date%type;
2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:
2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;

Line 2322: p_person_id_t per_all_assignments_f.person_id%type;

2318: p_accepted_termination_date per_periods_of_service.actual_termination_date%type;
2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:
2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;

Line 2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;

2319: p_primary_flag per_all_assignments_f.primary_flag%type;
2320:
2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;

Line 2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;

2320:
2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;

Line 2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;

2321: -- data required for message from table
2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;

Line 2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;

2322: p_person_id_t per_all_assignments_f.person_id%type;
2323: p_assignment_id_t per_all_assignments_f.assignment_id%type;
2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;

Line 2328: p_probation_period_t per_all_assignments_f.probation_period%type;

2324: p_assignment_number_t per_all_assignments_f.assignment_number%type;
2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;

Line 2329: p_probation_units_t per_all_assignments_f.probation_unit%type;

2325: p_eff_start_date_t per_all_assignments_f.effective_start_date%type;
2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;

Line 2330: p_organization_id_t per_all_assignments_f.organization_id%type;

2326: p_eff_end_Date_t per_all_assignments_f.effective_end_date%type;
2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;

Line 2331: p_job_id_t per_all_assignments_f.job_id%type;

2327: p_original_date_of_hire_t per_all_people_f.original_date_of_hire%type;
2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;

Line 2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;

2328: p_probation_period_t per_all_assignments_f.probation_period%type;
2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;

Line 2333: p_location_id_t per_all_assignments_f.location_id%type;

2329: p_probation_units_t per_all_assignments_f.probation_unit%type;
2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;

Line 2334: p_employment_category_t per_all_assignments_f.employment_category%type;

2330: p_organization_id_t per_all_assignments_f.organization_id%type;
2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;

Line 2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;

2331: p_job_id_t per_all_assignments_f.job_id%type;
2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;

Line 2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;

2332: p_assignment_status_type_id_t per_all_assignments_f.assignment_status_type_id%type;
2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;

Line 2337: p_frequency_t per_all_assignments_f.frequency%type;

2333: p_location_id_t per_all_assignments_f.location_id%type;
2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;

Line 2338: p_grade_id_t per_all_assignments_f.grade_id%type;

2334: p_employment_category_t per_all_assignments_f.employment_category%type;
2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;

Line 2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;

2335: p_business_group_id_t per_all_assignments_f.business_group_id%type;
2336: p_normal_hours_t per_all_assignments_f.normal_hours%type;
2337: p_frequency_t per_all_assignments_f.frequency%type;
2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;
2343:

Line 2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;

2338: p_grade_id_t per_all_assignments_f.grade_id%type;
2339: p_supervisor_id_t per_all_assignments_f.supervisor_id%type;
2340: p_final_process_date_t per_periods_of_service.final_process_date%type;
2341: p_accepted_termination_date_t per_periods_of_service.actual_termination_date%type;
2342: p_primary_flag_t per_all_assignments_f.primary_flag%type;
2343:
2344: l_transaction_id Number;
2345: l_transaction_id_canonical Varchar2(30);
2346:

Line 2379: per_all_assignments_f pas,

2375:
2376: primary_flag
2377:
2378: FROM per_all_people_f ppf,
2379: per_all_assignments_f pas,
2380: per_periods_of_service pos,
2381: per_periods_of_placement pop
2382: WHERE pas.assignment_id = p_ass_id
2383: AND pas.person_id = ppf.person_id