APPS.PAY_MX_PAYREG_PKG dependencies on HR_ORGANIZATION_UNITS

Line 1220: FROM hr_organization_units hou

1216: WHERE consolidation_set_id = cp_consolidation_set_id;
1217:
1218: CURSOR c_get_gre_name (cp_tax_unit_id NUMBER) IS
1219: SELECT hou.name
1220: FROM hr_organization_units hou
1221: WHERE hou.organization_id = cp_tax_unit_id;
1222:
1223: CURSOR c_get_le_id (cp_tax_unit_id NUMBER) IS
1224: SELECT hou.name

Line 1225: FROM hr_organization_units hou,

1221: WHERE hou.organization_id = cp_tax_unit_id;
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

Line 1438: FROM hr_organization_units hou

1434:
1435:
1436: CURSOR c_get_gre_name (cp_tax_unit_id number) IS
1437: SELECT hou.name
1438: FROM hr_organization_units hou
1439: WHERE hou.organization_id = cp_tax_unit_id;
1440:
1441: CURSOR csr_get_gre_tot(c_payroll_action_id NUMBER
1442: ,c_tax_unit_id NUMBER) IS