APPS.PQH_FR_ASSIGNMENT_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 239: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

235:
236: cursor common_info_csr is
237: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,
238: assignment_id,object_version_number,normal_hours,frequency,business_group_id
239: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
240: where person_id = p_person_id
241: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
242: and p_effective_date between effective_start_date and effective_end_date
243: and primary_flag ='Y';

Line 501: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

497:
498: cursor common_info_csr is
499: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,assignment_id
500: ,object_version_number,normal_hours
501: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
502: where person_id = p_person_id
503: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
504: and p_effective_date between effective_start_date and effective_end_date
505: and primary_flag ='Y';

Line 510: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

506: -- Note : CAGR_GRADE_DEF_ID is not used, assuming that will not be used by the customer, as the functionality is not delivered.
507:
508: Cursor earlier_affect_det_csr IS
509: Select segment27 PrimayAffectation
510: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
511: where assignment_id = p_assignment_id
512: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
513: and p_effective_date between effective_start_date and effective_end_date;
514:

Line 1200: hr_soft_coding_keyflex scl

1196: scl.segment9 "Working Hours Share",
1197: scl.segment19 "Reason For Part",
1198: scl.segment20 "Comments"
1199: FROM per_all_assignments_f asg,
1200: hr_soft_coding_keyflex scl
1201: WHERE asg.assignment_id = p_assignment_id
1202: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+)
1203: AND asg.effective_start_date >= p_effective_end_date
1204: AND NVL(asg.employment_category,p_employment_category) = p_employment_category

Line 1543: FROM per_all_assignments_f, hr_soft_coding_keyflex

1539: CURSOR csr_old_assign_record
1540: IS
1541: SELECT grade_ladder_pgm_id, grade_id, normal_hours, frequency,
1542: segment10 employee_category
1543: FROM per_all_assignments_f, hr_soft_coding_keyflex
1544: WHERE assignment_id = p_assignment_id
1545: AND p_effective_date BETWEEN effective_start_date
1546: AND effective_end_date
1547: AND per_all_assignments_f.soft_coding_keyflex_id = hr_soft_coding_keyflex.soft_coding_keyflex_id(+);

Line 1547: AND per_all_assignments_f.soft_coding_keyflex_id = hr_soft_coding_keyflex.soft_coding_keyflex_id(+);

1543: FROM per_all_assignments_f, hr_soft_coding_keyflex
1544: WHERE assignment_id = p_assignment_id
1545: AND p_effective_date BETWEEN effective_start_date
1546: AND effective_end_date
1547: AND per_all_assignments_f.soft_coding_keyflex_id = hr_soft_coding_keyflex.soft_coding_keyflex_id(+);
1548:
1549: --
1550: CURSOR csr_work_hrs_share IS
1551: SELECT nvl(scl.segment9,100) work_hour_share,

Line 1556: hr_soft_coding_keyflex scl

1552: nvl(employment_category,'CF') employment_category,
1553: normal_hours,
1554: frequency
1555: FROM per_all_assignments_f asg,
1556: hr_soft_coding_keyflex scl
1557: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1558: AND assignment_id = p_assignment_id
1559: AND p_effective_date between effective_start_date and effective_end_date
1560: AND primary_flag = 'Y';

Line 1874: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

1870:
1871:
1872: cursor info_admin_career_id is
1873: Select person_id, scl.segment26 admin_career_id, object_version_number
1874: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
1875: where assignment_id = p_assignment_id
1876: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1877: and p_effective_date between effective_start_date and effective_end_date;
1878:

Line 1883: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

1879: cursor common_info_csr (p_person_id in number)is
1880: Select people_group_id, establishment_id , scl.segment10 FrEmpCategory,
1881: assignment_id,object_version_number,normal_hours,frequency,business_group_id,
1882: organization_id, job_id, position_id
1883: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
1884: where person_id = p_person_id
1885: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1886: and p_effective_date between effective_start_date and effective_end_date
1887: and primary_flag ='Y';

Line 2053: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

2049:
2050:
2051: cursor info_admin_career_id is
2052: Select person_id, scl.segment26 admin_career_id, object_version_number
2053: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
2054: where assignment_id = p_assignment_id
2055: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2056: and p_effective_date between effective_start_date and effective_end_date;
2057:

Line 2200: from per_all_assignments_f asg, hr_soft_coding_keyflex scl

2196: -- to the secondary assingment.
2197:
2198: cursor info_admin_career_id is
2199: Select person_id, scl.segment26 admin_career_id, object_version_number
2200: from per_all_assignments_f asg, hr_soft_coding_keyflex scl
2201: where assignment_id = p_assignment_id
2202: and scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2203: and p_effective_date between effective_start_date and effective_end_date;
2204:

Line 2209: hr_soft_coding_keyflex scl

2205:
2206: Cursor assign_percent_affected is
2207: Select nvl(scl.segment25,0) Percenteffected
2208: From per_all_assignments_f assign,
2209: hr_soft_coding_keyflex scl
2210: Where person_id = l_person_id
2211: And assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2212: And assign.primary_flag = 'N'
2213: And p_effective_date Between effective_start_date And effective_end_date