DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on PER_GEN_HIERARCHY_NODES

Line 1226: per_gen_hierarchy_nodes greghn,

1222:
1223: CURSOR c_get_le_id (cp_tax_unit_id NUMBER) IS
1224: SELECT hou.name
1225: FROM hr_organization_units hou,
1226: per_gen_hierarchy_nodes greghn,
1227: per_gen_hierarchy_nodes leghn
1228: WHERE greghn.entity_id = fnd_number.number_to_canonical(cp_tax_unit_id)
1229: AND leghn.hierarchy_node_id = greghn.parent_hierarchy_node_id
1230: AND hou.organization_id = leghn.entity_id;

Line 1227: per_gen_hierarchy_nodes leghn

1223: CURSOR c_get_le_id (cp_tax_unit_id NUMBER) IS
1224: SELECT hou.name
1225: FROM hr_organization_units hou,
1226: per_gen_hierarchy_nodes greghn,
1227: per_gen_hierarchy_nodes leghn
1228: WHERE greghn.entity_id = fnd_number.number_to_canonical(cp_tax_unit_id)
1229: AND leghn.hierarchy_node_id = greghn.parent_hierarchy_node_id
1230: AND hou.organization_id = leghn.entity_id;
1231: