APPS.PAY_SG_IRAS_ARCHIVE dependencies on HR_ALL_POSITIONS_F

Line 3606: v_designation hr_all_positions_f.name%type;

3602: p_er_designation_type in hr_organization_information.org_information17%type,
3603: p_er_position_seg_type in hr_organization_information.org_information18%type)
3604: is
3605: --
3606: v_designation hr_all_positions_f.name%type;
3607:
3608: ---------------------------------------------------------------------------
3609: -- Bug 4688761 - Modified cursor to check the legal entity, and need get the
3610: -- latest primary assignment

Line 3694: hr_all_positions_f_tl pst,

3690: c_basis_end date) is
3691:
3692: select pst.name
3693: from per_assignments_f assign,
3694: hr_all_positions_f_tl pst,
3695: hr_all_positions_f pos,
3696: hr_soft_coding_keyflex hsc
3697: where assign.person_id = c_person_id
3698: and assign.assignment_id = c_assignment_id

Line 3695: hr_all_positions_f pos,

3691:
3692: select pst.name
3693: from per_assignments_f assign,
3694: hr_all_positions_f_tl pst,
3695: hr_all_positions_f pos,
3696: hr_soft_coding_keyflex hsc
3697: where assign.person_id = c_person_id
3698: and assign.assignment_id = c_assignment_id
3699: and pos.position_id = assign.position_id

Line 3764: hr_all_positions_f pos,

3760: 'SEGMENT29',ppd.segment29,
3761: 'SEGMENT30',ppd.segment30)
3762: from per_assignments_f assign,
3763: hr_soft_coding_keyflex hsc,
3764: hr_all_positions_f pos,
3765: hr_all_positions_f_tl pst,
3766: per_position_definitions ppd,
3767: hr_organization_units hou,
3768: hr_organization_information hoi,

Line 3765: hr_all_positions_f_tl pst,

3761: 'SEGMENT30',ppd.segment30)
3762: from per_assignments_f assign,
3763: hr_soft_coding_keyflex hsc,
3764: hr_all_positions_f pos,
3765: hr_all_positions_f_tl pst,
3766: per_position_definitions ppd,
3767: hr_organization_units hou,
3768: hr_organization_information hoi,
3769: fnd_id_flex_segments fifs,