APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on HR_SOFT_CODING_KEYFLEX

Line 343: hr_soft_coding_keyflex hsc,

339: national_identifier, full_name, employee_number, normal_hours,
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

Line 356: hr_soft_coding_keyflex hsck

352: past.assignment_status_type_id
353: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
354: and paaf.assignment_id = (select min (assignment_id)
355: from per_all_assignments_f asg,
356: hr_soft_coding_keyflex hsck
357: where person_id = papf.person_id
358: and hsck.soft_coding_keyflex_id =
359: asg.soft_coding_keyflex_id
360: and hsck.segment2 =

Line 420: hr_soft_coding_keyflex hsc,

416: national_identifier, full_name, employee_number, normal_hours,
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

Line 432: hr_soft_coding_keyflex hsck

428: and paaf.assignment_status_type_id =
429: past.assignment_status_type_id
430: and paaf.assignment_id = (select min (assignment_id)
431: from per_all_assignments_f asg,
432: hr_soft_coding_keyflex hsck
433: where person_id = papf.person_id
434: and hsck.soft_coding_keyflex_id =
435: asg.soft_coding_keyflex_id
436: and hsck.segment2 =

Line 671: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type

667:
668: /* Cursor to get the Organization No for the Local Unit based on the soft
669: coding keyflex id */
670: cursor csr_get_org_no (
671: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type
672: ) is
673: select org_information1
674: from hr_organization_information hoi, hr_soft_coding_keyflex hsc
675: where org_information_context = 'NO_LOCAL_UNIT_DETAILS'

Line 674: from hr_organization_information hoi, hr_soft_coding_keyflex hsc

670: cursor csr_get_org_no (
671: p_soft_coding_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type
672: ) is
673: select org_information1
674: from hr_organization_information hoi, hr_soft_coding_keyflex hsc
675: where org_information_context = 'NO_LOCAL_UNIT_DETAILS'
676: and hsc.segment2 = organization_id
677: and soft_coding_keyflex_id = p_soft_coding_keyflex_id;
678:

Line 689: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf

685: p_effective_date date,
686: p_job_id number
687: ) is
688: select segment3
689: from hr_soft_coding_keyflex hsc, per_all_assignments_f paaf
690: where paaf.job_id = p_job_id
691: and assignment_id = p_assignment_id
692: and p_effective_date between paaf.effective_start_date
693: and paaf.effective_end_date

Line 733: from hr_soft_coding_keyflex

729: cursor csr_get_lu_scl (
730: p_soft_coding_keyflex_id number
731: ) is
732: select nvl (segment2, '0')
733: from hr_soft_coding_keyflex
734: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
735:
736: --
737: --

Line 743: from hr_soft_coding_keyflex

739: cursor csr_get_pos_scl (
740: p_soft_coding_keyflex_id number
741: ) is
742: select nvl (segment3, 0)
743: from hr_soft_coding_keyflex
744: where soft_coding_keyflex_id = (p_soft_coding_keyflex_id);
745:
746: --
747: --

Line 866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck

862: p_assignment_id per_all_assignments_f.assignment_id%type,
863: p_local_unit hr_all_organization_units.organization_id%type)
864: is
865: select assignment_id
866: from per_all_assignments_f paaf ,hr_soft_coding_keyflex hsck
867: where person_id = p_person_id
868: and assignment_id <> p_assignment_id
869: and hsck.segment2 = to_char (p_local_unit)
870: and hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 880: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

876: p_local_unit hr_all_organization_units.organization_id%type)
877: is
878: select normal_hours,
879: hourly_salaried_code, hsc.segment3 position_code, frequency
880: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
881: where paaf.assignment_id = p_assignment_id
882: and hsc.segment2 = to_char (p_local_unit)
883: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
884: and p_effective_date between paaf.effective_start_date and paaf.effective_End_date;

Line 960: l_new_lu hr_soft_coding_keyflex.segment3%type;

956: l_job_id number;
957: l_empl_start_date date;
958: l_old_scl varchar2 (30);
959: l_new_scl varchar2 (30);
960: l_new_lu hr_soft_coding_keyflex.segment3%type;
961: l_old_lu hr_soft_coding_keyflex.segment3%type;
962: l_sickness_unpaid_start date;
963: l_sickness_unpaid_end date;
964: l_prev_hour_flag char (1);

Line 961: l_old_lu hr_soft_coding_keyflex.segment3%type;

957: l_empl_start_date date;
958: l_old_scl varchar2 (30);
959: l_new_scl varchar2 (30);
960: l_new_lu hr_soft_coding_keyflex.segment3%type;
961: l_old_lu hr_soft_coding_keyflex.segment3%type;
962: l_sickness_unpaid_start date;
963: l_sickness_unpaid_end date;
964: l_prev_hour_flag char (1);
965: /* Flag to set whether the hours have got changed during the period or not*/

Line 2716: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc

2712: p_effective_date date,
2713: p_local_unit number
2714: ) is
2715: select normal_hours, frequency
2716: from per_all_assignments_f paaf, hr_soft_coding_keyflex hsc
2717: where paaf.person_id = p_person_id
2718: and paaf.assignment_id <> p_assignment_id
2719: and paaf.normal_hours is not null
2720: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id