APPS.HRI_OPL_POSH dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 43: (business_group_id per_pos_structure_elements.business_group_id%TYPE

39: /******************************************************************************/
40:
41: /* Information to be held for each link in a chain */
42: TYPE g_link_record_type IS RECORD
43: (business_group_id per_pos_structure_elements.business_group_id%TYPE
44: ,position_id per_pos_structure_elements.parent_position_id%TYPE);
45:
46: /* Table type to hold information about the current chain */
47: TYPE g_chain_type IS TABLE OF g_link_record_type INDEX BY BINARY_INTEGER;

Line 44: ,position_id per_pos_structure_elements.parent_position_id%TYPE);

40:
41: /* Information to be held for each link in a chain */
42: TYPE g_link_record_type IS RECORD
43: (business_group_id per_pos_structure_elements.business_group_id%TYPE
44: ,position_id per_pos_structure_elements.parent_position_id%TYPE);
45:
46: /* Table type to hold information about the current chain */
47: TYPE g_chain_type IS TABLE OF g_link_record_type INDEX BY BINARY_INTEGER;
48:

Line 269: per_pos_structure_elements pse

265: pse.business_group_id
266: ,pse.subordinate_position_id
267: ,pse.parent_position_id
268: FROM
269: per_pos_structure_elements pse
270: WHERE pse.pos_structure_version_id = g_fetch_psv_id(p_index)) hier
271: START WITH hier.parent_position_id = g_fetch_top_pos_id(p_index)
272: CONNECT BY PRIOR hier.subordinate_position_id = parent_position_id;
273: /******************************/

Line 349: per_pos_structure_elements pse

345: ,psv.date_from
346: ,NVL(psv.date_to,g_end_of_time)
347: ,psv.business_group_id
348: FROM
349: per_pos_structure_elements pse
350: ,per_pos_structure_versions psv
351: ,per_position_structures pst
352: WHERE psv.pos_structure_version_id = pse.pos_structure_version_id
353: AND pst.position_structure_id = psv.position_structure_id

Line 357: FROM per_pos_structure_elements pse2

353: AND pst.position_structure_id = psv.position_structure_id
354: AND pst.primary_position_flag = 'Y'
355: AND NOT EXISTS
356: (SELECT NULL
357: FROM per_pos_structure_elements pse2
358: WHERE pse2.pos_structure_version_id = pse.pos_structure_version_id
359: AND pse2.subordinate_position_id = pse.parent_position_id);
360:
361: l_return_code PLS_INTEGER;