DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_SHARED_TYPES

Line 2720: from per_shared_types pst

2716: ,p_language_code in varchar2
2717: ) return number is
2718: cursor csr_lookup is
2719: select pst.shared_type_id
2720: from per_shared_types pst
2721: , per_shared_types_tl psttl
2722: where psttl.shared_type_name = p_shared_type_name
2723: and psttl.language = p_language_code
2724: and pst.shared_type_id = psttl.shared_type_id

Line 2721: , per_shared_types_tl psttl

2717: ) return number is
2718: cursor csr_lookup is
2719: select pst.shared_type_id
2720: from per_shared_types pst
2721: , per_shared_types_tl psttl
2722: where psttl.shared_type_name = p_shared_type_name
2723: and psttl.language = p_language_code
2724: and pst.shared_type_id = psttl.shared_type_id
2725: and pst.lookup_type = 'POSITION_AVAILABILITY_STATUS'