DBA Data[Home] [Help]

APPS.HRFASTANSWERS dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 1140: , per_org_structure_versions osv

1136: , cp_str_id Number )
1137: is
1138: select ose.org_structure_element_id
1139: from per_organization_structures ost
1140: , per_org_structure_versions osv
1141: , per_org_structure_elements ose
1142: where ost.business_group_id = cp_bus_id
1143: and ost.organization_structure_id = cp_str_id
1144: and ost.organization_structure_id = osv.organization_structure_id

Line 1193: , per_org_structure_versions osv

1189: , cp_str_id Number )
1190: is
1191: select osv.org_structure_version_id
1192: from per_organization_structures ost
1193: , per_org_structure_versions osv
1194: where ost.business_group_id = cp_bus_id
1195: and ost.organization_structure_id = cp_str_id
1196: and ost.organization_structure_id = osv.organization_structure_id
1197: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate);

Line 1243: , per_org_structure_versions v

1239: , cp_str_id Number )
1240: is
1241: select v.org_structure_version_id
1242: from per_organization_structures s
1243: , per_org_structure_versions v
1244: where s.business_group_id = cp_bus_id
1245: and s.organization_structure_id = cp_str_id
1246: and s.organization_structure_id = v.organization_structure_id
1247: and trunc(sysdate) between nvl(v.date_from,trunc(sysdate)) and nvl(v.date_to,sysdate);