APPS.PAY_NO_EERR_CONTINUOUS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 369: per_assignment_status_types past

365: hourly_salaried_code, hsc.segment3 position_code, frequency
366: from per_all_people_f papf,
367: per_all_assignments_f paaf,
368: hr_soft_coding_keyflex hsc,
369: per_assignment_status_types past
370: where papf.person_id between p_start_person and p_end_person
371: and paaf.person_id = papf.person_id
372: and paaf.business_group_id = papf.business_group_id
373: -- and paaf.primary_flag = 'Y'

Line 404: per_assignment_status_types past

400: hourly_salaried_code, hsc.segment3 position_code, frequency
401: from per_all_people_f papf,
402: per_all_assignments_f paaf,
403: hr_soft_coding_keyflex hsc,
404: per_assignment_status_types past
405: where paaf.person_id = papf.person_id
406: and papf.person_id between p_start_person and p_end_person
407: and paaf.business_group_id = papf.business_group_id
408: --and paaf.primary_flag = 'Y'

Line 438: from per_all_assignments_f paaf, per_assignment_status_types past

434: cursor csr_start_date (
435: p_assignment_id per_all_assignments_f.assignment_id%type
436: ) is
437: select min (effective_start_date)
438: from per_all_assignments_f paaf, per_assignment_status_types past
439: where assignment_id = p_assignment_id
440: and paaf.assignment_status_type_id =
441: past.assignment_status_type_id
442: and past.PER_SYSTEM_STATUS in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 522: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type

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

Line 525: from per_assignment_status_types

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

Line 831: l_user_status per_assignment_status_types.PER_SYSTEM_STATUS%type;

827: l_effective_start_date date;
828: l_lu_change_effective_date1 date;
829: l_job_change_effective_date1 date;
830: l_hour_value_reported number := 0;
831: l_user_status per_assignment_status_types.PER_SYSTEM_STATUS%type;
832: l_last_update_date date;
833: l_alter_change char (1);
834: l_lu_org_no hr_organization_information.org_information1%type;
835: l_hour_element_entry_id number;