APPS.PQH_WORKFLOW dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 80: from per_pos_structure_elements

76: begin
77: hr_utility.set_location('Entering pos_in_ph',10);
78:
79: select 'TRUE' into l_return
80: from per_pos_structure_elements
81: where subordinate_position_id = p_position_id
82: and pos_structure_version_id = p_pos_str_ver_id;
83:
84: hr_utility.set_location('Exiting pos_in_ph',100);

Line 93: from per_pos_structure_elements

89: begin
90: hr_utility.set_location('Exiting pos_in_ph',101);
91:
92: select 'TRUE' into l_return
93: from per_pos_structure_elements
94: where parent_position_id = p_position_id
95: and pos_structure_version_id = p_pos_str_ver_id;
96:
97: hr_utility.set_location('Exiting pos_in_ph',102);

Line 1043: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,

1039: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,
1040: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
1041: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
1042: p_cur_position_id in pqh_position_transactions.position_id%type,
1043: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
1044: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
1045: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1046: p_next_role_id out nocopy number,
1047: p_next_user_id out nocopy number,

Line 1315: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,

1311: procedure next_applicable_position(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1312: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1313: p_trans_id in pqh_routing_history.transaction_id%type,
1314: p_cur_position_id in pqh_position_transactions.position_id%type,
1315: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
1316: p_used_for in varchar2,
1317: p_position_id out nocopy pqh_position_transactions.position_id%type,
1318: p_status_flag out nocopy number,
1319: p_applicable_flag out nocopy boolean)

Line 2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,

2000: p_old_position_id in pqh_position_transactions.position_id%type,
2001: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
2002: p_cur_user_id in out nocopy fnd_user.user_id%type,
2003: p_cur_user_name in out nocopy fnd_user.user_name%type,
2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
2006: p_cur_person_id out nocopy fnd_user.employee_id%type,
2007: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2008: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,

Line 4520: from per_pos_structure_elements

4516: p_position_id out nocopy pqh_position_transactions.position_id%type,
4517: p_status_flag out nocopy number ) as
4518: cursor c1(l_position_id number) is
4519: select parent_position_id
4520: from per_pos_structure_elements
4521: where subordinate_position_id = l_position_id
4522: and pos_structure_version_id = p_pos_str_ver_id ;
4523: l_proc varchar2(256) := g_package||'ph_next_user';
4524: l_effective_date date;