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 442: per_assignment_status_types past

438: hourly_salaried_code, hsc.segment3 position_code, frequency
439: from per_all_people_f papf,
440: per_all_assignments_f paaf,
441: hr_soft_coding_keyflex hsc,
442: per_assignment_status_types past
443: where paaf.person_id = papf.person_id
444: and papf.person_id between p_start_person and p_end_person
445: and paaf.business_group_id = papf.business_group_id
446: --and paaf.primary_flag = 'Y'

Line 515: from per_all_assignments_f paaf, per_assignment_status_types past

511: cursor csr_start_date (
512: p_assignment_id per_all_assignments_f.assignment_id%type
513: ) is
514: select min (effective_start_date)
515: from per_all_assignments_f paaf, per_assignment_status_types past
516: where assignment_id = p_assignment_id
517: and paaf.assignment_status_type_id =
518: past.assignment_status_type_id
519: and past.PER_SYSTEM_STATUS in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');

Line 688: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type

684: --
685: --
686: /* Cursor to get Assignment Status */
687: cursor csr_get_assignment_status (
688: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
689: ) is
690: select PER_SYSTEM_STATUS
691: from per_assignment_status_types
692: where assignment_status_type_id = p_assignment_status_type_id;

Line 691: from per_assignment_status_types

687: cursor csr_get_assignment_status (
688: p_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type
689: ) is
690: select PER_SYSTEM_STATUS
691: from per_assignment_status_types
692: where assignment_status_type_id = p_assignment_status_type_id;
693:
694: --
695: --

Line 997: l_user_status per_assignment_status_types.PER_SYSTEM_STATUS%type;

993: l_effective_start_date date;
994: l_lu_change_effective_date1 date;
995: l_job_change_effective_date1 date;
996: l_hour_value_reported number := 0;
997: l_user_status per_assignment_status_types.PER_SYSTEM_STATUS%type;
998: l_last_update_date date;
999: l_alter_change char (1);
1000: l_lu_org_no hr_organization_information.org_information1%type;
1001: l_hour_element_entry_id number;