APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 340: per_assignment_status_types past

336: hourly_salaried_code, hsc.segment3 position_code, frequency
337: from per_all_people_f papf,
338: per_all_assignments_f paaf,
339: hr_soft_coding_keyflex hsc,
340: per_assignment_status_types past
341: where papf.person_id between p_start_person and p_end_person
342: and paaf.person_id = papf.person_id
343: and paaf.business_group_id = papf.business_group_id
344: -- and paaf.primary_flag = 'Y'

Line 378: per_assignment_status_types past

374: hourly_salaried_code, hsc.segment3 position_code, frequency
375: from per_all_people_f papf,
376: per_all_assignments_f paaf,
377: hr_soft_coding_keyflex hsc,
378: per_assignment_status_types past
379: where paaf.person_id = papf.person_id
380: and papf.person_id between p_start_person and p_end_person
381: and paaf.business_group_id = papf.business_group_id
382: --and paaf.primary_flag = 'Y'

Line 421: from per_all_assignments_f paaf, per_assignment_status_types past

417: cursor csr_start_date (
418: p_assignment_id per_all_assignments_f.assignment_id%type
419: ) is
420: select min (effective_start_date)
421: from per_all_assignments_f paaf, per_assignment_status_types past
422: where assignment_id = p_assignment_id
423: and paaf.assignment_status_type_id =
424: past.assignment_status_type_id
425: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 524: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type

520: --
521: --
522: /* Cursor to get Assignment Status */
523: cursor csr_get_assignment_status (
524: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
525: ) is
526: select per_system_status
527: from per_assignment_status_types
528: where assignment_status_type_id = p_assignment_status_type_id;

Line 527: from per_assignment_status_types

523: cursor csr_get_assignment_status (
524: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
525: ) is
526: select per_system_status
527: from per_assignment_status_types
528: where assignment_status_type_id = p_assignment_status_type_id;
529:
530: --
531: --

Line 759: l_user_status per_assignment_status_types.per_system_status%type;

755: l_lu_change_effective_date1 date;
756: l_job_change_effective_date1 date;
757: l_hour_value_reported number := 0;
758: l_event_group_details csr_event_group_details%rowtype;
759: l_user_status per_assignment_status_types.per_system_status%type;
760: l_old_user_status per_assignment_status_types.per_system_status%type;
761: l_last_update_date date;
762: l_alter_change char (1);
763: l_lu_org_no hr_organization_information.org_information1%type;

Line 760: l_old_user_status per_assignment_status_types.per_system_status%type;

756: l_job_change_effective_date1 date;
757: l_hour_value_reported number := 0;
758: l_event_group_details csr_event_group_details%rowtype;
759: l_user_status per_assignment_status_types.per_system_status%type;
760: l_old_user_status per_assignment_status_types.per_system_status%type;
761: l_last_update_date date;
762: l_alter_change char (1);
763: l_lu_org_no hr_organization_information.org_information1%type;
764: l_hour_element_entry_id number;