APPS.HR_MASS_MOVE_API dependencies on PER_SHARED_TYPES

Line 852: l_system_type_cd per_shared_types.system_type_cd%TYPE;

848: p_copied_to_old_table_flag varchar2(80);
849: --
850: -- Added as part of fix for bug 2943725
851: --
852: l_system_type_cd per_shared_types.system_type_cd%TYPE;
853: l_current_system_type_cd per_shared_types.system_type_cd%TYPE;
854: --
855: cursor csr_old_pos is
856: select

Line 853: l_current_system_type_cd per_shared_types.system_type_cd%TYPE;

849: --
850: -- Added as part of fix for bug 2943725
851: --
852: l_system_type_cd per_shared_types.system_type_cd%TYPE;
853: l_current_system_type_cd per_shared_types.system_type_cd%TYPE;
854: --
855: cursor csr_old_pos is
856: select
857: position_definition_id

Line 1073: cursor csr_avail_status(p_system_type_cd IN per_shared_types.system_type_cd%TYPE) is

1069: where pbg.business_group_id = l_business_group_id;
1070: --
1071: -- Moved and modified as part of fix for bug 2943725
1072: --
1073: cursor csr_avail_status(p_system_type_cd IN per_shared_types.system_type_cd%TYPE) is
1074: select shared_type_id
1075: from per_shared_types
1076: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
1077: and system_type_cd = p_system_type_cd

Line 1075: from per_shared_types

1071: -- Moved and modified as part of fix for bug 2943725
1072: --
1073: cursor csr_avail_status(p_system_type_cd IN per_shared_types.system_type_cd%TYPE) is
1074: select shared_type_id
1075: from per_shared_types
1076: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
1077: and system_type_cd = p_system_type_cd
1078: and business_group_id IS NULL;
1079: --

Line 1085: per_shared_types pst

1081: --
1082: cursor csr_current_status is
1083: select pst.system_type_cd
1084: from hr_positions_f hpf,
1085: per_shared_types pst
1086: where lookup_type = 'POSITION_AVAILABILITY_STATUS'
1087: and pst.shared_type_id = hpf.availability_status_id
1088: and hpf.position_id = p_position_id
1089: and p_date_effective between hpf.effective_start_date