APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 472: from hr_soft_coding_keyflex hsck,

468: pjo.previous_job_id = p_previous_job_id;
469:
470: cursor cur_corps is
471: select to_number(hsck.segment7) corps_id
472: from hr_soft_coding_keyflex hsck,
473: fnd_id_flex_structures fifs,
474: per_all_assignments_f paf,
475: per_all_people_f ppf
476: where hsck.id_flex_num = fifs.id_flex_num

Line 1027: l_corps_id hr_soft_coding_keyflex.segment7%TYPE;

1023: AND asg.effective_end_date;
1024:
1025:
1026: l_assignment_id per_assignments_f.assignment_id%TYPE;
1027: l_corps_id hr_soft_coding_keyflex.segment7%TYPE;
1028:
1029: CURSOR csr_corps_period
1030: IS
1031: SELECT asg.effective_start_date, asg.effective_end_date

Line 2680: select segment7 from hr_soft_coding_keyflex where id_flex_num in

2676: p_bg_id IN per_all_organization_units.organization_id%TYPE)
2677: RETURN VARCHAR2 IS
2678:
2679: cursor csr_corps is
2680: select segment7 from hr_soft_coding_keyflex where id_flex_num in
2681: (select id_flex_num from fnd_id_flex_structures fifs
2682: where id_flex_structure_code = 'FR_STATUTORY_INFO.'
2683: and fifs.application_id = 800 and fifs.id_flex_code = 'SCL')
2684: and soft_coding_keyflex_id in