DBA Data[Home] [Help]

APPS.PAY_EOSURVEY_PKG dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 122: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%type)

118: locations under that establishment and including the entity_id of that est.*/
119:
120: CURSOR c_est_loc
121: (l_est_id per_gen_hierarchy_nodes.entity_id%type,
122: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%type)
123: IS
124: SELECT entity_id,parent_hierarchy_node_id
125: FROM per_gen_hierarchy_nodes
126: WHERE hierarchy_version_id = l_hierarchy_version_id