[Home] [Help]
1039: INTO l_position_id
1040: , l_job_id
1041: , l_organization_id
1042: , l_location_id
1043: FROM per_organization_units org
1044: , per_positions pos
1045: WHERE pos.name = p_position
1046: AND pos.business_group_id + 0 = l_business_group_id
1047: AND pos.organization_id = org.organization_id
1119: if p_source_organization_id IS NULL then null;
1120: else
1121: SELECT organization_id
1122: INTO l_source_organization_id
1123: FROM per_organization_units
1124: WHERE organization_id = p_source_organization_id
1125: AND business_group_id + 0 = l_business_group_id
1126: AND l_effective_start_date BETWEEN date_from
1127: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
1436: INTO l_position_id
1437: , l_job_id
1438: , l_organization_id
1439: , l_location_id
1440: FROM per_organization_units org
1441: , per_positions pos
1442: WHERE pos.name = p_position
1443: AND pos.business_group_id + 0 = l_business_group_id
1444: AND pos.organization_id = org.organization_id
1861: INTO l_position_id
1862: , l_job_id
1863: , l_organization_id
1864: , l_location_id
1865: FROM per_organization_units org
1866: , per_positions pos
1867: WHERE pos.name = p_position
1868: AND pos.business_group_id + 0 = l_business_group_id
1869: AND pos.organization_id = org.organization_id
2002: INTO l_position_id
2003: , l_job_id
2004: , l_organization_id
2005: , l_location_id
2006: FROM per_organization_units org
2007: , per_positions pos
2008: WHERE pos.name = p_position
2009: AND pos.business_group_id + 0 = l_business_group_id
2010: AND pos.organization_id = org.organization_id
2071: if p_source_organization_id IS NULL then null;
2072: else
2073: SELECT organization_id
2074: INTO l_organization_id
2075: FROM per_organization_units
2076: WHERE organization_id = p_source_organization_id
2077: AND business_group_id + 0 = l_business_group_id
2078: AND l_effective_start_date BETWEEN date_from
2079: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));