APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 344: per_assignment_status_types past

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

Line 421: per_assignment_status_types past

417: hourly_salaried_code, hsc.segment3 position_code, frequency
418: from per_all_people_f papf,
419: per_all_assignments_f paaf,
420: hr_soft_coding_keyflex hsc,
421: per_assignment_status_types past
422: where paaf.person_id = papf.person_id
423: and papf.person_id between p_start_person and p_end_person
424: and paaf.business_group_id = papf.business_group_id
425: --and paaf.primary_flag = 'Y'

Line 504: from per_all_assignments_f paaf, per_assignment_status_types past

500: cursor csr_start_date (
501: p_assignment_id per_all_assignments_f.assignment_id%type
502: ) is
503: select min (effective_start_date)
504: from per_all_assignments_f paaf, per_assignment_status_types past
505: where assignment_id = p_assignment_id
506: and paaf.assignment_status_type_id =
507: past.assignment_status_type_id
508: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 700: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type

696: --
697: --
698: /* Cursor to get Assignment Status */
699: cursor csr_get_assignment_status (
700: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
701: ) is
702: select per_system_status
703: from per_assignment_status_types
704: where assignment_status_type_id = p_assignment_status_type_id;

Line 703: from per_assignment_status_types

699: cursor csr_get_assignment_status (
700: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
701: ) is
702: select per_system_status
703: from per_assignment_status_types
704: where assignment_status_type_id = p_assignment_status_type_id;
705:
706: --
707: --

Line 935: l_user_status per_assignment_status_types.per_system_status%type;

931: l_lu_change_effective_date1 date;
932: l_job_change_effective_date1 date;
933: l_hour_value_reported number := 0;
934: l_event_group_details csr_event_group_details%rowtype;
935: l_user_status per_assignment_status_types.per_system_status%type;
936: l_old_user_status per_assignment_status_types.per_system_status%type;
937: l_last_update_date date;
938: l_alter_change char (1);
939: l_lu_org_no hr_organization_information.org_information1%type;

Line 936: l_old_user_status per_assignment_status_types.per_system_status%type;

932: l_job_change_effective_date1 date;
933: l_hour_value_reported number := 0;
934: l_event_group_details csr_event_group_details%rowtype;
935: l_user_status per_assignment_status_types.per_system_status%type;
936: l_old_user_status per_assignment_status_types.per_system_status%type;
937: l_last_update_date date;
938: l_alter_change char (1);
939: l_lu_org_no hr_organization_information.org_information1%type;
940: l_hour_element_entry_id number;