APPS.PAY_SG_IRAS_ARCHIVE dependencies on HR_ALL_POSITIONS_F

Line 3476: v_designation hr_all_positions_f.name%type;

3472: p_er_designation_type in hr_organization_information.org_information17%type,
3473: p_er_position_seg_type in hr_organization_information.org_information18%type)
3474: is
3475: --
3476: v_designation hr_all_positions_f.name%type;
3477:
3478: ---------------------------------------------------------------------------
3479: -- Bug 4688761 - Modified cursor to check the legal entity, and need get the
3480: -- latest primary assignment

Line 3564: hr_all_positions_f_tl pst,

3560: c_basis_end date) is
3561:
3562: select pst.name
3563: from per_assignments_f assign,
3564: hr_all_positions_f_tl pst,
3565: hr_all_positions_f pos,
3566: hr_soft_coding_keyflex hsc
3567: where assign.person_id = c_person_id
3568: and assign.assignment_id = c_assignment_id

Line 3565: hr_all_positions_f pos,

3561:
3562: select pst.name
3563: from per_assignments_f assign,
3564: hr_all_positions_f_tl pst,
3565: hr_all_positions_f pos,
3566: hr_soft_coding_keyflex hsc
3567: where assign.person_id = c_person_id
3568: and assign.assignment_id = c_assignment_id
3569: and pos.position_id = assign.position_id

Line 3634: hr_all_positions_f pos,

3630: 'SEGMENT29',ppd.segment29,
3631: 'SEGMENT30',ppd.segment30)
3632: from per_assignments_f assign,
3633: hr_soft_coding_keyflex hsc,
3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3638: hr_organization_information hoi,

Line 3635: hr_all_positions_f_tl pst,

3631: 'SEGMENT30',ppd.segment30)
3632: from per_assignments_f assign,
3633: hr_soft_coding_keyflex hsc,
3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3638: hr_organization_information hoi,
3639: fnd_id_flex_segments fifs,